PDA

View Full Version : VBA HELP



david7281
02-12-2013, 01:59 AM
Hi I have recorded a macro that it goes to a celll in sheet 1 and copys its contetnts to a diffrent sheet in cell a1.
But how do i tell it that if cell a1 has something in it then jump to the next cell down.

Many Thanks
David

Bob Phillips
02-12-2013, 02:07 AM
Post the code so that we can help.

david7281
02-12-2013, 02:56 AM
Range("b" & Cells(Rows.Count, "b").End(xlUp).Row + 1).Select

That is the answer
Many Thanks Guys