Posted to microsoft.public.excel.programming

Soo Cheon Jheong[_2_] Soo Cheon Jheong[_2_] is offline

external usenet poster

Posts: 46

Formula Referencing Worksheet Name by Variable

Hi,

Sub TEST()

With ActiveSheet
.Range("B2").Formula = "='" & Sheets.Add.Name & "'!A7"
.Activate
End With

End Sub

--
Regards,
Soo Cheon Jheong
_ _
^ ^
V

Reply With Quote

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
Replace worksheet without affecting the referencing formula	Jay	Excel Discussion (Misc queries)	1	May 7th 09 03:11 AM
Variable Worksheet Name in Formula	pdberger	Excel Worksheet Functions	4	March 16th 08 12:28 AM
Formula Referencing Worksheet Name by Variable	Mister T	Excel Programming	0	August 5th 04 12:13 AM
referencing worksheet as a variable	crew3407	Excel Programming	3	April 28th 04 08:48 PM
Referencing variable	Lee	Excel Programming	1	December 4th 03 04:07 PM

All times are GMT +1. The time now is 04:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us