Thread: indirect macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LadyHawk LadyHawk is offline
external usenet poster
 
Posts: 10
Default indirect macro

Is there a way to change cells that currently read
='week 1'!$a$17
to read
=indirect("'week1'!$A$17")
I have a few thousand cells to change each one referncing a different
cell...for instance Cell A18, Cell A19 etc...