I have been building a program in Excel and one of my lines of code just stopped working. I am just selecting a different sheet, say I am Sheet1 and I want to jump to Sheet2:
I have always used this in the past but it doesn't work anymore, it just stays on the first sheet. What am I doing wrong?
Sheets("Sheet2").Activate
Thanks guys.
Last edited by wmorrison49; 10-27-2008 at 03:33 PM.
you can use "worksheets" instead of sheet.
Didn't work. I have tried
and nothing is working. I am trying to walkthrough the macro using F8 and it just skips over these lines like do nothing. I had these exact lines before and they worked just fine. What the heck is going on here? It's saying "Select method of range class failed."Sheets("Sheet2").Activate Sheets("Sheet2").Select Worksheets("Sheet2").Activate Worksheets("Sheet2").Select
Last edited by wmorrison49; 10-27-2008 at 01:51 PM.
It just started working again, even though I didn't change anything. Did I just fall victim to the sometimes work, sometimes don't nature of macros?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks