Solved

Move active worksheet to far left

Posted on 2014-02-12
2
289 Views
Last Modified: 2014-02-12
Can someone provide me with the code to make my active worksheet the first worksheet [i.e. far left]

thanks
0
Comment
Question by:Jagwarman
2 Comments
 
LVL 3

Accepted Solution

by:
Sreeram earned 500 total points
ID: 39852955
Hi .

Try this

      ActiveSheet.Move Before:=Sheets(1)

Thanks
0
 

Author Closing Comment

by:Jagwarman
ID: 39853360
thanks
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now