Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Pull up the right Sheet Please - Excel 2010

  Asked By: Nancy    Date: Jun 03    Category: MS Office    Views: 1253
  

I have a long and complicated autoexec macro that ends with the following 3 lines:

Sheets("May").Select
Range("A1").Select
End Sub

The Sheets in my Workbook are named Jan, Feb, Mar... Every month I go in and edit the macro so that the current fiscal month's sheet is pulled up.

I would like "Sheets("May").Select" to get its value from a cell: Budget!A13 which is in the same workbook. The value in Budget!A13 is text format and its value is the current fiscal month.

Thanks in advance for any help or suggestions.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Pull up the right Sheet Please - Excel 2010 Or get search suggestion and latest updates.




Tagged: