move two columns to the right and then find next cell above that i
 

nonemtpy and move two columns two the right and then paste data?


How do I do that?

br
Sverre

move two columns to the right and then find next cell above that i
 

Let's say your non empty is A5
Range("A5").offset(0,2).value = range("A5").value

if you need to do this for a range then
For each cell in Range("A5:A50")
cell.offset(0,2).value = cell.value
next cell


--
JNW


"sverre" wrote:

nonemtpy and move two columns two the right and then paste data?


How do I do that?

br
Sverre