Hi. I need a method of copying the values in cells F4 to K20 which also have formulas in and pasting the values only to cells N4 to S20 and would like to do this using a command button. I'm a real newbie. Thanks
Hi. I need a method of copying the values in cells F4 to K20 which also have formulas in and pasting the values only to cells N4 to S20 and would like to do this using a command button. I'm a real newbie. Thanks
Last edited by FDibbins; 10-21-2013 at 11:04 AM. Reason: Title changed
The macro you request can be easily created by using the record function. Go to the View tab on the ribbon - macros - record macro. Once recorded, you can create a shape and assign this macro to is, thus creating a command button.
Welcome too the Forum.
Maybe:
Please Login or Register to view this content.
Hi and welcome to the forum
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the help - it works for me - sorting out the thread title now.
JC
Hi Expert,
i am satendra kumar from noida india. i am new in vba macro please help me. i have a userform with many records in textbox. so i want copy records from textbox to the new workbook.
thanks
satendra
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks