Posted to microsoft.public.excel.programming

Kieran[_45_] Kieran[_45_] is offline

external usenet poster

Posts: 1

For...Each Loop Problem

SuperJas try

Sub LoopTest()

Dim DummyCell as Range
Dim MyRegion as Range
Dim Value() as String
Dim i as Integer

i=1

Set MyRegion = Cells(1,1).CurrentRegion.Columns(6)
Redim Value(myregion.cells.count)
For Each DummyCell in MyRegion

Value(i)=DummyCell.Value
i=i+1

Next DummyCell

End Su

--
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
do while loop problem	April	Excel Discussion (Misc queries)	4	October 18th 09 07:51 PM
loop problem	teepee[_3_]	Excel Discussion (Misc queries)	3	December 31st 08 11:09 AM
Problem with Loop	Mike	Excel Programming	7	February 26th 04 09:12 PM
For..Next loop problem	Dwaine Horton	Excel Programming	1	February 18th 04 12:12 AM
loop problem	joao	Excel Programming	4	November 6th 03 02:01 PM

All times are GMT +1. The time now is 05:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us