So i took a look at how to avoid using Select and Activate in the other post Here:
How to avoid using Select in Excel VBA macros
However, that other post still fails to mention how I could avoid using Activate or Select in some VBA code like this example below:
ThisWorkbook.Sheets("Data").Activate
ThisWorkbook.Sheets("Data").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
With Selection.Interior
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorDark1
.TintAndShade = -0.149998474074526
.PatternTintAndShade = 0
End With
I need to figure out how I can avoid using .Activate and also how to avoid using .Select because this code gives me an error on BOTH of these.....
these errors started happening after I upgraded from Excel 2010 to Excel 2013...
Please help !