Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Is there any function in visual basic that will return the current worksheet name? I am currently working on a program that tries to assign it to a variable and I cannot seem to get the syntax right. ![]() If anyone can help that would be great. Thanks in advance! -- wild_fish99 ------------------------------------------------------------------------ wild_fish99's Profile: http://www.excelforum.com/member.php...fo&userid=8345 View this thread: http://www.excelforum.com/showthread...hreadid=490639 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
myvar = Activesheet.Name
-- Regards, Tom Ogilvy "wild_fish99" wrote in message ... Is there any function in visual basic that will return the current worksheet name? I am currently working on a program that tries to assign it to a variable and I cannot seem to get the syntax right. ![]() If anyone can help that would be great. Thanks in advance! -- wild_fish99 ------------------------------------------------------------------------ wild_fish99's Profile: http://www.excelforum.com/member.php...fo&userid=8345 View this thread: http://www.excelforum.com/showthread...hreadid=490639 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Thanks!! :) -- wild_fish99 ------------------------------------------------------------------------ wild_fish99's Profile: http://www.excelforum.com/member.php...fo&userid=8345 View this thread: http://www.excelforum.com/showthread...hreadid=490639 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding the current year | Excel Worksheet Functions | |||
finding 75 days before current date | Excel Worksheet Functions | |||
Finding values based on current month | Excel Worksheet Functions | |||
Finding Current Path | Excel Programming | |||
Finding the current date | Excel Programming |