Hi guys,
Sorry for the simple question but I keep getting an error after I run my macro. Its a simple macro to create folder, save file (.xls and .pdf), increase the invoice number and clear some data.
I tested the same code ( Example: Range("A1").Value = Range("A1").Value + 1) in a new workbook and it works fine by itself.
But when I run the one in my invoice template it doesn't work.
Could you guys help me here....this is the code:
Cheers
Please Login or Register to view this content.
Change:
To:Please Login or Register to view this content.
Please Login or Register to view this content.
hint : text+1 thats not the same as value+1
you have :
Please Login or Register to view this content.
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
Thank you guys
John: changing it to invoice = Range("G4").Value +1 didnt work
Hulpeloos: I changed it to
andPlease Login or Register to view this content.
but it still not working?Please Login or Register to view this content.
What should I change it to to make it work? I know its simple but I must be missing something there.
Cheers
Last edited by cemartinho; 10-18-2013 at 06:07 PM.
Thank you guys
John: changing it to invoice = Range("G4").Value +1 didnt work
Hulpeloos: I changed it to
Select Code copy to clipboard
invoice = Sheets("Invoice").Range("G4").Value
and
Select Code copy to clipboard
invoice = Range("G4").Value + 1
but it still not working?
What should I change it to to make it work? I know its simple but I must be missing something there.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks