Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Finding the current worksheet name


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Finding the current worksheet name

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Finding the current worksheet name


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding the current year BrittaniMV Excel Worksheet Functions 3 May 15th 09 07:34 PM
finding 75 days before current date vikkib Excel Worksheet Functions 3 May 29th 08 08:26 PM
Finding values based on current month Paulc Excel Worksheet Functions 5 November 29th 06 12:19 PM
Finding Current Path Mike C Excel Programming 1 April 7th 05 09:14 PM
Finding the current date serge Excel Programming 2 February 18th 04 10:39 AM


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"