Posted to microsoft.public.excel.programming

Andoni[_11_] Andoni[_11_] is offline

external usenet poster

Posts: 1

Need Help: Dynamic Range

this will take the range comprised in B2 and the last non empty cell i
column B:

Range(Range("B2"),Range("B65536").end(xlup)

--
Message posted from http://www.ExcelForum.com

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
Dynamic range	Eva	Excel Worksheet Functions	0	December 15th 09 05:28 PM
Dynamic Range	Dave	Excel Worksheet Functions	1	April 8th 08 04:21 AM
Dynamic range	pelachrum	Excel Discussion (Misc queries)	5	July 2nd 06 09:27 PM
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
Excel 2000 VBA - Set Print Range in dynamic range	sub_pop[_5_]	Excel Programming	2	July 27th 04 08:01 PM

All times are GMT +1. The time now is 04:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us