Chrissim16
asked on
Excel VBA Copy previous row cell value
Hi there,
I have an Excel file where in the B column the uneven row cells have a value but the even row cells do not have value. I would like to copy the value of the uneven cell to the even cell. For example, B2= B1, B4=B3,B6=B5 etc. It should also look solely at this range, not at the whole sheet. I need a VB solution for this. I tried to record a macro using the special values (F5) for blanks, but then I get a circular reference. Anyone got an idea?
I have an Excel file where in the B column the uneven row cells have a value but the even row cells do not have value. I would like to copy the value of the uneven cell to the even cell. For example, B2= B1, B4=B3,B6=B5 etc. It should also look solely at this range, not at the whole sheet. I need a VB solution for this. I tried to record a macro using the special values (F5) for blanks, but then I get a circular reference. Anyone got an idea?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@ShivaKK: Yours almost worked perfectly, but it dod not copy the value for the last row, but thanks very much for help