Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 12:37 AM
ramsdesk
 
Posts: n/a
Default how to get name of worksheet in a workbook?


If I have several worksheets in an Excel file, is there a way to look
for a particular worksheet (by name) and use it in a formula...

thanks,


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile: http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=273027


  #2   Report Post  
Old October 28th 04, 12:50 AM
Kenjiro Yagi
 
Posts: n/a
Default

Hi Ramsdesk,

If you are just trying to enter a formula in a cell. Say you want to get a
value from another sheet, you can type

[name of sheet]![range]

So, if I want to get Cell A1 from sheet named "John"

John!A1

Would work.

If you are trying to use it in VBA, try

Sheets("John").range("A1")

If you want to find out a sheet name

Msgbox Sheets("John").name
Or
Activesheet.name
Etc. etc.

Good luck!

Kenjiro Yagi
http://www.spoofee.com



On 10/27/04 4:37 PM, in article ,
"ramsdesk" wrote:


If I have several worksheets in an Excel file, is there a way to look
for a particular worksheet (by name) and use it in a formula...

thanks,


  #3   Report Post  
Old October 28th 04, 07:11 AM
Frank Kabel
 
Posts: n/a
Default

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Regards
Frank Kabel
Frankfurt, Germany

"ramsdesk" schrieb im
Newsbeitrag ...

If I have several worksheets in an Excel file, is there a way to look
for a particular worksheet (by name) and use it in a formula...

thanks,


--
ramsdesk
---------------------------------------------------------------------

---
ramsdesk's Profile:

http://www.excelforum.com/member.php...o&userid=15705
View this thread:

http://www.excelforum.com/showthread...hreadid=273027




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
How to open a workbook with a specific worksheet displayed by defa ThaiNB New Users to Excel 2 January 21st 05 07:11 AM
copy COLUMN from 1 worksheet to another (in a different workbook) DavidB Excel Discussion (Misc queries) 3 January 15th 05 03:47 PM
How to print a worksheet but number the pages by workbook Frank Clayton Excel Discussion (Misc queries) 2 January 10th 05 11:52 PM
move the worksheet tabs in a workbook to left Boriss Excel Discussion (Misc queries) 1 December 6th 04 09:28 PM
make large worksheet from workbook Cowtoon Excel Discussion (Misc queries) 5 December 6th 04 09:24 PM


All times are GMT +1. The time now is 02:18 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017