Thread: Insert rows but keep references in Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RichterCa RichterCa is offline
external usenet poster
  
Posts: 2
Default Insert rows but keep references in Excel
Thanks, that was a big help. It's not perfect, but I'm getting closer.

"Mike H" wrote:

Hi,

use indirect

=INDIRECT("January!A1")

Mike
Reply With QuoteReply With Quote