06-22-2001, 01:41 PM
I need to loop through each row of data in an Excel spreadsheet and acquire each cell (A1, A2, etc) and save them as variables in my VBA app in order to build a file with the data.
Can someone give me a hint or clue.
Thanks so much,
Look up the UsedRange property (so that you know how much you actually need to search), the Range property, and the Cells property.
Those should at least point you in the right direction.
06-22-2001, 03:04 PM
There is no information on the forum for UsedRange. Really I need one example of how to get A1 cell into a variable.
06-23-2001, 04:42 AM
x = Sheets("sheet1").Cells(1, 1).Value
This what you mean?
06-23-2001, 06:34 AM
THANKS SO MUCH.
Now all I have to do is loop through it and I'm THERE!!
You are the BEST and you saved my life.
Thanks a Million