copying down the formula just for data

  • Thread starter Thread starter childofthe1980s
  • Start date Start date
C

childofthe1980s

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
 
That's exactly what I needed, Mike! Thank you! I apologize, for the
confusion!

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
 
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
 
Back
Top