I am attempting to select a specific Excel sheet within my Excel VBA Code. In selecting say "Sheet2" I am writing Excel headers and would also like, etc. like this
The problem is that since the .Range and .Selection properties are on the same level as .Sheets property, I can't seem to work with Sheet2 like I need to as in the code below. I'm sure there's a way to get around this but I haven't figured it out yet.
Thank you for your help Experts!
.Selection.Interior.ColorIndex = 1
.Selection.Font.Name = "Tahoma"
.Selection.Font.ColorIndex = 2
.Selection.Font.Size = 10
.Selection.Font.Italic = True