Link to home
Start Free TrialLog in
Avatar of Chrissim16
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?
ASKER CERTIFIED SOLUTION
Avatar of balatheexpert
balatheexpert

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chrissim16
Chrissim16

ASKER

@Bala: Thanks, it worked perfectly!!
@ShivaKK: Yours almost worked perfectly, but it dod not copy the value for the last row, but thanks very much for help