Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
[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 & sorry for the double post (?) Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does this code not work? | Excel Discussion (Misc queries) | |||
Why this code is not work? | Excel Worksheet Functions | |||
Why my code do not work : - ( | Excel Programming | |||
Why my code do not work : - ( | Excel Programming | |||
Why my code do not work : - ( | Excel Programming |