Thread: Why doesn't this line work in 2007
View Single Post
  #1  
Old 07-18-2008, 05:25 PM
Lift Off Lift Off is offline
Registered User
  
Join Date: 13 Apr 2004
Posts: 30
Lift Off is an unknown quantity at this point
Why doesn't this line work in 2007
The macro has this line of code and works well in Excel 2003. Can someone explain why this line stops the macro using 2007?

Code:
z = Workbooks("master").Worksheets("sheet1").Cells(Rows.Count, 2).End(xlUp).Row + 4
Work around???

Thanks,
Last edited by VBA Noob; 07-18-2008 at 06:08 PM..
Reply With Quote