Returning to the last sheet used

[jonco]

I might be trying to simplify this too much and that may be why it isn't
working. (Rewording my question)

I have a macro that manipulates data on a worksheet when a button is pushed
on that worksheet.

In that macro I want a line to store the worksheet name in case I need to go
back and change the data just entered.
Here is the code that is trying to store the sheet name:
LastCust = ActiveSheet.Name ' Stores the Active Sheets name in a
variable called LastCust

On another sheet (an Index Sheet) I have a button that I want to be able to
push if I need to change the last transaction I made on the customer's
sheet. Here is the code to recall that sheet and make it the active sheet
again (code in a different macro but in the same workbook). (It isn't
working):
Worksheets(LastCust).Activate ' Activates the worksheet that was saved
using the variable LastCust

Once activated (or selected) I can make the code make the changes I need.
I just can't get the proevious sheet activated again.

I'd like to be able to do this as simply as possible without using user
forms, and special add-ins and functions if possible.

As always, Thanks
Jonco

 

[Paul B]

jonco, Above you code try and put
Public LastCust As String


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[jonco]

I get a runtime error 9 - Subscript out of range on this line:
Worksheets(LastCust).Activate (This is the macro that opens the last sheet
up)

Jonco

Paul B wrote:
jonco, Above you code try and put
Public LastCust As String

 

[Tom Ogilvy]

this line

Public LastCust As String


needs to be at the top of a general module (insert=>Module) and only
there.

 

[jonco]

Tom (and others),
Thanks, That was the tip I needed. I'm really grateful for all the help I
get here. You guys really know your stuff.

Jonco