copying down the formula just for data

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
 
C

childofthe1980s

That's exactly what I needed, Mike! Thank you! I apologize, for the
confusion!

childofthe1980s
 
J

Jacob Skaria

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying down a formula only where there is data 3
How to copy only to cells where there is data 4
Stop copying down values 1
Copying a formula to a range 2
Fill Down based on count in another sheet 2
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
copying down a blank column 5
Insert Row and Formula 1

Top