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
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