Posted to microsoft.public.excel.programming

Ernst Guckel[_4_] Ernst Guckel[_4_] is offline

external usenet poster

Posts: 34

Range collection

Hello,

Is ther a limit to the # of cells one can use in a range collection? IE:

For Each rCell In
Range("C17:Q17,S17:T17,V17:AC17,AH17:AO17,AQ17:AR1 7,C21:Q27,S21:T27,V21:AC27,AH21:AO27,AQ21:AR27,C31 :Q37,S31:T37,V31:AC37,AH31:AO37,AQ31:AR37,C41:Q47, S41:T47,V41:AC47,AH41:AO47,AQ41:AR47,C51:Q57,S51:T 57,V51:AC57,AH51:AO57,AQ51:AR57,C62:Q63,S62:T63,V6 2:AC63,AH62:AO63,AQ62:AR63")

rCell.Value = rData(i)

i = i + 1

Next

This does not work...

Ernst.

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
Collection	Todd Huttenstine	Excel Programming	4	December 17th 04 09:41 PM
Range objects in a collection	Corey B	Excel Programming	2	September 25th 04 06:24 PM
Deleting named ranges by looping through range collection	agarwaldvk[_11_]	Excel Programming	3	August 3rd 04 01:00 AM
Adding Range to Worksheet Names Collection	Keith Willshaw	Excel Programming	2	March 5th 04 09:17 AM
calculating and adding a range to a collection	marola20[_2_]	Excel Programming	2	March 1st 04 03:24 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us