| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I alphabetize data excluding words like "a" and "the"? | Excel Discussion (Misc queries) | |||
| creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| How can I convert a Number into words. Ex: "10" as "Ten" | Excel Worksheet Functions | |||
| XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select | Excel Programming | |||
Threaded Mode
