I am working in Excel 2010 and I have problems referencing where I want to format.
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorDark1
.TintAndShade = 0
.PatternTintAndShade = 0
I have the above code but find it really difficult to select this place and it is with mainly this statement Columns("B:B").Select.
I try and many varients like it
but it does not like this at all and I get it to work.
Can someone please tell me the correct way to reference an area to then format it or do something with it?