Joe 90 wrote:
Bob

Found my first problem:


Code:
--------------------

Worksheets("Sheet1").Select (or Activate)
[end code]

causes a breakout from Application.ScreenUpdating=false

So I am trying to reference the range I need using:


Code:
--------------------

Worksheets("Sheet1").Range("J2", Range("J2").End(xlDown)). Copy
Worksheets("Sheet2").Range("b2")
[end code]

but I get an object error. I need to reference the range with .End because
the size of range starting at J2 will keep changing.

All/any help greatly appreciated

Joe



Should it be this?


Code:
--------------------

Worksheets("Sheet1").Range("J2"*:* Range("J2").End(xlDown)). Copy
Worksheets("Sheet2").Range("b2")
[end code]


I think you need to have a colon to help select the range, not the comma that was there. I hope that works... I could sure use a formula that select ranges like that.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/