Excel Macro If a cell is blank, how to paste?

Microsoft Excel 2003 (full product)
January 25, 2011 at 10:21:47
Specs: Windows XP
Hi,

I have a list of prices. I want a macro that when a button is pushed, the data will go from one cell to another. However, I have 10 rows at the top of the page. I want to price to go into the last blank cell of those ten rows....that is if a price was already in a cell, it would fill the new data into the one below it.

I know it has to be some sort of "if" "then" code, but I am in way over my head!

Please help!

~Deb


See More: Excel Macro If a cell is blank, how to paste?

Report •


#1
January 25, 2011 at 21:43:53
re: ...when a button is pushed, the data will go from one cell to another.

errr...what data?

You need to be a lot more specific before we can help.

Please post an example of your layout, after reading the How To referenced in the next line.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question