Need help with worksheet spanning macro

  • Thread starter Thread starter NorCalIC
  • Start date Start date
N

NorCalIC

I'm trying to write a macro to copy cells B2:B4 from worksheet A to
the next blank cell range in column B, worksheet B.

I've been able to cobble together a macro that works on the same
worksheet. ex. copy cell B2, worksheet A to the next blank cell
in column C, worksheet A. But I can't figure out how to get a
cellrange from one worksheet to the next blank cellrange in another
worksheet.

Is this possible?

NorCalIC
 
I'm trying to write a macro to copy cells B2:B4 from worksheet A to
the next blank cell range in column B, worksheet B.

I've been able to cobble together a macro that works on the same
worksheet. ex. copy cell B2, worksheet A to the next blank cell
in column C, worksheet A. But I can't figure out how to get a
cellrange from one worksheet to the next blank cellrange in another
worksheet.
Click to expand...

If you define 'next blank cell' as the blank cell immediately below the
bottommost nonblank cell, then this could be done as

Worksheets("Sheet1").Range("A1").Copy _
Destination:=Worksheets("Sheet2").Range("B65536").End(xlUp).Offset(1, 0)
 
Back
Top