Populate specific cells and address specific worksheets
Posted on 2012-09-20
I have a macro that I'd like to modify to format specific cells. Just as a couple of examples, how would I, say set Cell C4 to the string value "Hello World" and have it centered? And how would I set, say cells B10 thru G10 to the RGB color value 200, 200, 200?
Finally, my macro currently runs a routine on every worksheet in my workbook. However, I'd like to have it skip "Sheet1" as Sheet1 is of a totally different format and I don't want the macro run against is. My macro currently reads:
For Each sht In ActiveWorkbook.Worksheets
How do I modify it to something like:
For Each sht In ActiveWorkbook.Worksheets EXCEPT SHEET1