Hello All,

I have a macro which is copying data from B3:B8 and pasting it in the blank cells of Column B.
It is helpful the only problem is that it is pasting data to all blank cells in Column B.

Need your help to restrict the pasting of data in blank cells off Column B adjacent A column.

Code:
Range("b3:b8").Copy

Dim ws As Worksheet
Set ws = ActiveSheet

For Each cell In ws.Columns(2).Cells
If IsEmpty(cell) = True Then cell.PasteSpecial:
Next cell

regards,
Shan