Thanks all, the issue has been resolved! You are all great!
Natron
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Proble
>
> Thanks again for all of the replies, below is the code I put together to
> do this task in case anyone is interested...
>
LastRow = Range("C" & Rows.Count).End(xlUp).row
Range("A1:B" & LastRow).SpecialCells(xlCellTypeBlanks).FormulaR1C1 =
"=R[-1]C"
Columns("A:B").Copy
Colu