Hello:

I'm going to program a macro in Excel 2003 that will copy the results an If,
Then statement straight down the column. The statement is based on data in
the column to the left.

Anyway, I just want to copy the results down the column for data that is in
the column to the left. I don't want every cell in the If, Then column to be
filled. Otherwise, call 65k and so forth down the spreadsheet gets filled in.

Is there a formula or keystroke that I can use and that the macro will
utilize, without having to do VBA programming?

Thanks!

childofthe1980s

To find the last filled row in a column

the below returns last filled row in ColA.
lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row

If this post helps click Yes
---------------
Jacob Skaria


"childofthe1980s" wrote:

Hello:

I'm going to program a macro in Excel 2003 that will copy the results an If,
Then statement straight down the column. The statement is based on data in
the column to the left.

Anyway, I just want to copy the results down the column for data that is in
the column to the left. I don't want every cell in the If, Then column to be
filled. Otherwise, call 65k and so forth down the spreadsheet gets filled in.

Is there a formula or keystroke that I can use and that the macro will
utilize, without having to do VBA programming?

Thanks!

childofthe1980s

Well, although I appreciate the help, Mike H.'s suggestion was actualy what I
needed. It's nice and neat, and I don't have to do any programming.

Again, though, thanks for chiming in!!!

childofthe1980s

"Jacob Skaria" wrote:

To find the last filled row in a column

the below returns last filled row in ColA.
lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row

If this post helps click Yes
---------------
Jacob Skaria


"childofthe1980s" wrote:

Hello:

I'm going to program a macro in Excel 2003 that will copy the results an If,
Then statement straight down the column. The statement is based on data in
the column to the left.

Anyway, I just want to copy the results down the column for data that is in
the column to the left. I don't want every cell in the If, Then column to be
filled. Otherwise, call 65k and so forth down the spreadsheet gets filled in.

Is there a formula or keystroke that I can use and that the macro will
utilize, without having to do VBA programming?

Thanks!

childofthe1980s