Determine Column

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>