Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VB in Excel
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |