Posted to microsoft.public.excel.programming

Norman Jones Norman Jones is offline

external usenet poster

Posts: 5,302

Selecting ranges with Cells()

Hi Robotman

Set Rng = Range("A1").Resize(1,5)

Alternatively:

Set Rng = Cells(1,1).Resize(1,5)

---
Regards,
Norman

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
Selecting ranges with Cells()	robotman	Excel Programming	3	May 1st 07 10:15 PM
Selecting First and Last Cells in Ranges	Magnivy	Excel Programming	6	May 29th 06 04:46 AM
Selecting multiple ranges using 'Cells' notation	Pete[_22_]	Excel Programming	4	June 30th 05 05:42 PM
Selecting ranges of cells	Dale Fye	Excel Programming	5	March 10th 05 12:50 AM
Selecting two ranges of unadjacent cells	CTInt04	Excel Programming	3	July 7th 04 07:48 PM

All times are GMT +1. The time now is 06:42 AM.

About Us

"It's about Microsoft Excel"