Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I make references to cells in subroutines relative?
For example, if part of my subroutine is: Range("A5:D33").Select then I insert or delete cells in the spreadsheet, the references to these cells in the macro stay the same, and are thus incorrect. They always have to be updated manually. How can I make these change automatically when I modify the spreadsheet? Or is there a better way to reference cells in the worksheet? Thanks Atreides |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming Cells Using Relative Cell References | Excel Worksheet Functions | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Relative, absolute & mixed references in many cells | Excel Worksheet Functions | |||
Module to make all absolute references relative | Excel Programming | |||
Using named cells in relative references | Excel Programming |