| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
maintain absolute reference when inserting rows
I have 2 worksheets within a spreadsheet - one is the data, one the report. I
have a macro that inserts a new row on the data table at row 5. I always want my report to reflect the data in row 5. I used an absolute reference for R5C1 in my report but every I insert a new row on the data table, the reference moves to R6C1. Can anyone help? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDIRECT FUNCTION - I want to freeze reference when inserting rows | Excel Worksheet Functions | |||
| Reference Problem w/ inserting rows | Excel Discussion (Misc queries) | |||
| Maintain Relative Reference After Inserting a Column | Excel Worksheet Functions | |||
| Using absolute cell refernce and inserting rows | Excel Worksheet Functions | |||
| Conditional Formatting Reference / Inserting Rows | Excel Worksheet Functions | |||
Threaded Mode
