I need to loop through all the rows in a spreadsheet and load the data into
various
columns in a table. How do I refer to each column in each row without hard
coding the row number? For instance, in each row I loop through I want to
save off column A into a variable. I need to know how to code that.

Thanks.

for i = 1 to 10
var = cells(i,"A").Value
Next

--
Regards,
Tom Ogilvy

"csbennett" wrote in message
...
I need to loop through all the rows in a spreadsheet and load the data
into
various
columns in a table. How do I refer to each column in each row without
hard
coding the row number? For instance, in each row I loop through I want to
save off column A into a variable. I need to know how to code that.

Thanks.

iLastRow = Cells(Rows.Count,"A").End(xlUp),Row
For i = 1 to iLastRow
myVar = Cells(i,"A").Value
Next i

This is incomplete, as I assume you will do something with myVar, but
hopefully it will get you started.

--
HTH

Bob Phillips

"csbennett" wrote in message
...
I need to loop through all the rows in a spreadsheet and load the data
into
various
columns in a table. How do I refer to each column in each row without
hard
coding the row number? For instance, in each row I loop through I want to
save off column A into a variable. I need to know how to code that.

Thanks.

Thank you. That helps!

"Bob Phillips" wrote:


iLastRow = Cells(Rows.Count,"A").End(xlUp),Row
For i = 1 to iLastRow
myVar = Cells(i,"A").Value
Next i

This is incomplete, as I assume you will do something with myVar, but
hopefully it will get you started.

--
HTH

Bob Phillips

"csbennett" wrote in message
...
I need to loop through all the rows in a spreadsheet and load the data
into
various
columns in a table. How do I refer to each column in each row without
hard
coding the row number? For instance, in each row I loop through I want to
save off column A into a variable. I need to know how to code that.

Thanks.