Posted to microsoft.public.excel.programming

rodchar

external usenet poster

Posts: 80

iterate my rows

hi all,

let's say i have 2 rows and 2 columns

row1col1 row1col2
row2col1 row2col2

is there a way in a macro or something to iterate each row, taking each
column and adding it to a new single column? so the result would look like
the following

row1col1
row1col2
row2col1
row2col2

thanks,
rodchar

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
Iterate rows of spreadsheet(s}\Get values	gh	Excel Programming	1	May 8th 08 03:18 PM
Iterate rows, add like values - an easier way?	Ed from AZ	Excel Programming	1	April 3rd 08 06:09 PM
Iterate Thru Cells	Kelvin	Excel Programming	4	September 5th 07 10:18 AM
Can't iterate thru a row with For	peter	Excel Programming	2	January 7th 05 04:46 AM
Iterate columns	wired	Excel Programming	9	November 14th 03 11:14 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us