View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default 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