ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   fill row color on a specified worksheet (https://www.excelbanter.com/excel-programming/308684-fill-row-color-specified-worksheet.html)

GJones

fill row color on a specified worksheet
 
Hi Jeff;

You probably need to select the sheet and then do the fill.



Sheets("TheCorrectSheetName").Select

Hope it helps,

Greg
-----Original Message-----
I am trying to fill 2 colors on different rows on the 2nd

worksheet. the
colors are filled to the right rows, but wrong worksheet

(it always fills the
1st worksheet instead).


.



All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com