Not so experienced in VBA and need help on VBA macro on a calculation sheet that i have made.
I want to make a button to copy the sheet and paste it into a new sheet, removing formulas and paste everything as values.
When trying script i found online i can't make them to to work so im a little bit frustrated :-)
Thanks in advance
Espenlor
Use your Macro Recorder.
Select the developer tab
Select record macro
Record yourself copying and pasting your data
Select the developer tab
Select Stop recording.
Now you are in a position to be able to paste a rough macro onto this forum for us to look at.
Please remember to use Code Tags.
RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found [URL="http://www.excelforum.com/misc.php?do=bbcode"]here[/URL
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
This is the code i manage to get with record.
But it doesn't work
Please Login or Register to view this content.
Last edited by Espenlor; 08-26-2017 at 10:51 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Your code can be reduced to:-
Please Login or Register to view this content.
What did you intend it to do?
Last edited by mehmetcik; 08-26-2017 at 11:10 AM.
Thanks for quick answer.
Tried this but get errors on first command here
Please Login or Register to view this content.
attache the pictures on the error here.Errors-VBA-Copy.PNG
Make sure of the sheet name .. May be there is extra space at the end of the sheet !!
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hello again.
The sheetname are correct, with no spaces.
As you can see this is the error message
Errors-VBA-Copy-1.PNG
Where are you running the Macro from?
Does the active workbook have a sheet named "Bestillingark"
Running the macro in the same workbook, called Bestillingark.xlsb
I upload the sheet here.
Hi
There is nothing wrong with the Macro
Your Sheet is corrupted.
I copied the sheet to a new workbook and it now works.
I downloaded and tried, i see the code are running but the new duplicated sheet in a new workbook is not showing.
It works here
Try restarting your pc before opening this workbook.
Hello again, and thanks for good help.
I had to use the file you sent and rebuild my formulas on that.
How to you clean documents when they are corrupted as mine where ?
I have another question to.
In this sheet i have 2 hidden sheets, one with the hole stock of products and another with vlookup on postnumber sheet.
When i run your macro, is is quick to delete those to hidden sheets ??
Br
Espenlor
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks