View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_77_] Steve[_77_] is offline
external usenet poster
 
Posts: 17
Default R1C1 reference to worksheets?

Is it possible to use R1C1 referencing to other worksheets in a file?
I have files that use a different worksheet for each month, and some of
the cells on a sheet pull info from the previous month's worksheet.
When I copy the Apr sheet, for example, and make it May, it would be
nice for those cells to simply reference the previous sheet in the
file, rather than having to do a search and replace for all references
to Apr!.