using vba to copy

June 23, 2016 at 00:20:25
Specs: windows z
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


See More: using vba to copy

Report •


#1
June 23, 2016 at 21:11:19
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.


Report •

#2
June 24, 2016 at 05:48:47
I want to name a cell to match te tab name

Report •

#3
June 24, 2016 at 06:13:27
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.


Report •

Related Solutions


Ask Question