Posted to microsoft.public.excel.programming

mangesh_yadav[_275_] mangesh_yadav[_275_] is offline

external usenet poster

Posts: 1

Cell Reference is Worksheet Name in VB Code

Set Summary = Worksheets(Range("B3"))

or

Set Summary = Worksheets(worksheets("Sheet_name").Range("B3"))

Mangesh

--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=377971

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Use text from a cell reference in vba code.	JackyJ	Excel Discussion (Misc queries)	1	October 4th 10 07:57 AM
Altering code to reference the worksheet before the active worksheet	KimberlyC	Excel Programming	8	March 15th 05 10:26 PM
Replacing hard code with reference to a cell value	jojo	Excel Programming	2	March 6th 05 02:51 PM
Code To Insert Cell Reference	Carl Bowman	Excel Programming	6	February 13th 05 09:51 PM
How do I reset the LastUsed cell reference from code.	Henry[_4_]	Excel Programming	2	October 12th 03 09:34 PM

All times are GMT +1. The time now is 05:57 AM.

About Us

"It's about Microsoft Excel"