Posted to microsoft.public.excel.programming

jindon[_25_] jindon[_25_] is offline

external usenet poster

Posts: 1

Range selection

try

Code:
--------------------

Sub test()
With Sheets("Sheet1")
.Range(.Range("b1").Value).Select
End With
End Sub
--------------------

--
jindon
------------------------------------------------------------------------
jindon's Profile: http://www.excelforum.com/member.php...o&userid=13135
View this thread: http://www.excelforum.com/showthread...hreadid=387724

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
VBA - Selection Instead of Range	Cue	Excel Discussion (Misc queries)	2	January 15th 10 05:08 PM
Narrow Range based on Selection in Another Range	David	Excel Discussion (Misc queries)	3	July 1st 07 05:12 PM
Identifying a selection of a selection of a range	swimfast	Excel Worksheet Functions	1	March 1st 07 02:51 AM
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue.	jonH	Excel Programming	3	June 7th 04 09:13 PM
Creating range name for a range selection	Mervyn Thomas	Excel Programming	1	January 26th 04 05:18 PM

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

About Us

"It's about Microsoft Excel"