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.