PDA

View Full Version : VBA Tab Reference



Dimitriy
07-13-2009, 02:11 PM
Hey Everyone,

I was wondering if it's possible to reference a particular cell when I am selecting a tab in VBA? For example,

Sheets("Budget2009").Select

this is what I currently have. Is there a way to reference a cell that says "Budget2009" instead of typing in the tab name itself in the code? I don't want to hardcode this macro, but have it be dynamic so that it points to a different tab as the name in the cell changes.

Thanks in advance,

Dimitriy

Bob Phillips
07-13-2009, 02:17 PM
Worksheets(Activesheet.Range("A2").Value).Select

Dimitriy
07-13-2009, 02:27 PM
Thanks a bunch!