VBA look for cell next to first blank, copy and paste

Hi there,

I need a vba code that looks in a particular sheet, in a particular column for the first unpopulated cell, then copies the value of the first cell on the right of the blank cell just found, and finally pastes the copied value to the first blank cell in another column in another worksheet.

I have been trying for some time, but not luck, would appreciate you help. Thank you.

Give this a try:

Please Login or Register  to view this content.

Originally Posted by maniacb

Dim col1, col2, c, g As Range
Dim lr1, lr2, u As Long

Just pointing out that for the above declarations, only 'g' will be a Range variable and 'u' a Long variable... the rest will be declared as Variants. In VBA, you must declare each individual variable as to its data type otherwise it will default to being a Variant.