Why are macros creating so many "Activecell" words??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That's unusuall
I've never seen it I suppose you could do a replacement in your Macro Editor

Replace ActiveCell. With Nothing
 
It appears that if you record with the recorder in 'Relative Reference' mode
then the activecell stuff appears. Apparently Excels way to figure out where
it is. If you switch to absolute, you shouldn't see the activecell
references at the beginning of each line.
 
In the recording toolbar, the right button toggles between relative and
absolute. I suggest you have click it and placed it in relative mode.
Start recording a macro so it appears and click the right button. Then
perform a few actions and stop recording. See if that fixes it.
 
Back
Top