Why are macros creating so many "Activecell" words??
I've been happily recording macros for years. Suddenly, on a new PC, almost
every line of code begins with "Activecell" as shown below. Instead of a
simple "Range("A1").Select", it creates "ActiveCell.Offset(-27,
-2).Range("A1").Select ".
How do I make it stop doing that - make the "Activecell" stuff go away?
ActiveCell.Cells.Select
ActiveCell.Cells.EntireColumn.AutoFit
ActiveCell.Offset(4, 0).Range("A1").Select
ActiveCell.Offset(-27, -2).Range("A1").Select
Activecell.Help!!!!
Activecell.TIA
Activecell.Paul
|