View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Atreides Atreides is offline
external usenet poster
 
Posts: 41
Default How do I make references to cells in subroutines relative?

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