Excel previous selected worksheet

Y

ycgq

New Member
Joined
Sep 20, 2011
Messages
6
Can you please tell me the code used to go to the previously selected worksheet?

The one below does not help:
ActiveSheet.Previous.Activate 'go to the left of the active worksheet
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
Welcome to the Board!

This is odd. I have been here for years, and haven't seen a question like this, and now I have seen this question three times in the last week alone! Is everyone in the same class together?:laugh:

In any event, here is the code I helped someone with last week to do this: http://www.mrexcel.com/forum/showthread.php?t=579066
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Checking for Worksheets that already exist
2
Replies
11
Views
329
Logit
Logit
D
  • Solved
How to copy a worksheet and update a cell showing the date in increments
Replies
4
Views
267
AlphaFrog
AlphaFrog
R
  • Solved
Macro To Move Files - Will Not Move .msg or .csv files
Replies
4
Views
105
rachel06
R
C
  • Question Question
How to automatically paste the data from one sheet to another using VBA
Replies
4
Views
282
Alex Blakenburg
A
M
  • Solved
VBA to Insert Mismatched Row in separate worksheet
2 3
Replies
21
Views
777
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,597
Messages
6,179,813
Members
452,945
Latest member
Bib195

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top