In Cell A1 put Sheet1 or Sheet2. this formula will return the value from Cell
A1 on that sheet. What it does is allows you to build a Sheet!cell address
that you want to reference...

=indirect(A1 & "!A1")

--
HTH...

Jim Thomlinson


"justvree" wrote:

No... didn't know there was one. How does that work (I'll do a search in the
meantime)

"Jim Thomlinson" wrote:

Have you tried using the indirect worksheet function?
--
HTH...

Jim Thomlinson


"justvree" wrote:

What I have is a list of names, and a value beside it. Each name has it's
own sheet within the workbook. I'm trying to call a macro/VB script in order
for it to go to the worksheet I need, pull the info and put it into the value
beside the name in the list. If I hard code the name itself, I can get it to
go to the worksheet, pull the information I need and put it back on the first
worksheet. But how can I say "Go to the worksheet with the name in this
cell"?
Sheets("Nicole").Activate - works
Sheets(ActiveCell.Value).Activate - is what I want to do - but it's not
working. What's in the "quotes" I want to populate with the name in the cell.

How do I do this? CAN I do this, or am I just crazy? :) Any help will be
appreciated.