View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jared
 
Posts: n/a
Default How to change a tab name with cell reference and formula?

I would like to automatically change a tab's name from cell A1 but the
problem starts because cell A1 is in reference from a different sheet so it
automatically changes and i don't input it manually. All tries i made worked
only manually using the VBA.

Cell A1 inputs: =""&Intro!A3&" 7"
How can i change Cell "A3" in Sheet "Intro" So the tab's name will change
accordingly?

Thanks, Jared