I am working with invoices created in exel. I would like to copy the last used invoice to a new sheet and rename the tab to the next increasement nr example 30001 must become 30002 i would then like to rename a cell in the sheet to the same name as the sheet. using vba please help message edited by PamelaE
re: "rename a cell in the sheet to the same name as the sheet." Do you mean that you want name a cell with the sheet name or that you want the contents of the cell to match the sheet name.
Those are 2 very different things.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
I want to name a cell to match te tab name
OK, what cell do you want to name? The code needs to know that. BTW...just to make sure that we are on the same page, please review the following information and confirm that this is what you want to do. I don't want to do extra work that doesn't meet your requirements.
http://www.contextures.com/xlNames0...
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Ad Choices