I get a Run-Time Error 32809 on code written in Excel 2010 and now executed in 2013 when it hits the line Sheets("New Data").select . Unbelievable huh ?? "Application-defined or object-defined error" . The syntax is perfect and has never error'd before. Does anyone have any idea why this code suddenly stops working ??
Try replacing withCode:Application.GOTO worksheets("New Data").Cells(1)
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
I have had this error in the past as well using:
Would it always be preferable to use the above method?Code:Sheets("RawData").Activate 'AND Sheets("RawData").Select
Are there specific times when each one of these is better suited? Is one more efficient then the other?Code:Application.GOTO worksheets("New Data").Cells(1)
Using Excel 2010
Posting Permissions
Reply With Quote
Bookmarks