| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem Recording Macros in Excel
When I record macros in excel the macro is being recorded
in visual basic language that is different from what I am used to seeing. The macro will become messed up if I add or change rows in the excel spreadsheet - since the macro will not update the cells it references since visual basic does not HARD CODE the cell - it uses a relative navigation system to locate cells or worksheets. This never happened when I used Excel before in a previous Company, but I don't know what version it was. Right now I am using Excel 2002 SP2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recording macros | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
| How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
| Macros not recording | Excel Discussion (Misc queries) | |||
| Excel macro recording problem | Excel Programming | |||
Threaded Mode
