LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCP JCP is offline
external usenet poster
 
Posts: 1
Default Looping through Columns then Rows

Hi Guys - I'm struggling with this. I have a spreadsheet (CSV file)
generated from a VBA module in MSP which extracts specific data. The
output file that I'm opening in Excel depends upon the MSP project that
I run the other code against so, I don't know how many colunms or rows
will be in use. What I need to do is for each row used, loop through
each column used in that row and concatenate required cells values into
a temporary string that I can output to a file. Then clear this string
and move on to the next row. I can't seem to figure out the correct
sequence of the counters and where to clear dowm the temp string value.

Any ideas gratefully received

Best Rgds

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
looping through rows and columns mattguerilla Excel Discussion (Misc queries) 1 March 20th 07 05:14 PM
looping across columns in range? Amy Excel Discussion (Misc queries) 3 July 19th 05 08:01 PM
Looping thru columns Robert Excel Programming 5 June 15th 05 09:48 AM
Looping through columns teresa Excel Programming 2 December 31st 04 07:25 PM
Looping thru columns beyond Z John Pierce Excel Programming 3 January 23rd 04 12:17 AM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"