I have two columns of data, column B a current observed price and colum
A a last observed price. At the end of a macro I want to copy th
current observed price to last observed price and clear the current.
The problem is that there are many blanks in the current observe
price, and I don't want a price in column A to be overwritten with
blank cell.
I'm trying to build a loop on column B where if cell value < "" the
copy the cell, but can't get the code right. Can anyone help? Currentl
I have-

Range("v65536").End(xlUp).Select
Range("v5", ActiveCell).Select
For Each cell In Selection
If cell.Value < "" Then
ActiveCell.Copy
Paste.cell.Offset(-1, 0)
End If
Next cell

The problem is the ActiveCell.Copy and the paste code- what should i
be?
Any help greatly appreciated!
Pau

--
Message posted from http://www.ExcelForum.com