Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for present sheet
Hi, I need to know the command to record a sheet to a variable. So i ca run a macro which will return to the same sheet it started it. something like: a = presentSheet.Value Thx a lo -- kanuva ----------------------------------------------------------------------- kanuvas's Profile: http://www.excelforum.com/member.php...fo&userid=2791 View this thread: http://www.excelforum.com/showthread.php?threadid=48481 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for present sheet
Hi Kanuvas,
Try: Dim Sh as Worksheet Set Sh = ActiveSheet --- Regards, Norman "kanuvas" wrote in message ... Hi, I need to know the command to record a sheet to a variable. So i can run a macro which will return to the same sheet it started it. something like: a = presentSheet.Value Thx a lot -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=484816 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for present sheet
Thank you for the quick response Using that how do i then select that sheet something like: sh.select -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=484816 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locating if a Sheet is present in a workbook | Excel Discussion (Misc queries) | |||
testing whether a sheet is present | Excel Programming | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
getting the sheet names present in a work book???? | Excel Programming | |||
finding a value thats present more than once in a sheet | Excel Programming |