View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default Why are macros creating so many "Activecell" words??

That's unusuall
I've never seen it I suppose you could do a replacement in your Macro Editor

Replace ActiveCell. With Nothing


--
When you lose your mind, you free your life.


"Paul" wrote:

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