fcell

  1. S

    VBA Format Cell Range Based

    Hello everyone, I have a set of numbers in cell range A1 through A11 I would like to format any number that matches the value in cell C1 The following code works but I wanted to ask if the code can be converted to RGB? .ColorIndex = 6 Sub ColorCellsTest2() Dim wS As Worksheet Dim...
  2. A

    Same VBA code for multipage 1st and 2nd page

    Hey community, I am using same VBA code ( to search from sheet1 ) and trying to use same code for sheet2 ( on multipages 2nd page ) i am copy-pasting same code and changing sheet name on second code. but for some reason it is not working on second paage of multipage. i am getting error ...
  3. K

    what is wrong with this code in that it works fine in one workbook, but gives me 'run-time error '1004' in a differeent workbook?

    I have a "test workbook" that I use when I'm trying to figure out how to make something work... then after I fiddle with the code enough to (finally) get it to work the way i need to, I copy it over to my main workbook. Well, i have checked every conceivable thing that I thought it could be...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top