loop thru cells from excel to variables

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,
Andrea

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.

There is no information on the forum for UsedRange. Really I need one example of how to get A1 cell into a variable.

Thanks,
Andrea

Hi,

Sub main()
Dim x
x = Sheets("sheet1").Cells(1, 1).Value
MsgBox x
End Sub

This what you mean?

Yes.Yes.Yes!!!!
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
Andrea