Copy past using VBA
Closed
ntmn8r
Posts
3
Registration date
Sunday November 13, 2016
Status
Member
Last seen
November 17, 2016
-
Nov 13, 2016 at 07:47 PM
cody-peter Posts 2 Registration date Tuesday November 29, 2016 Status Member Last seen November 30, 2016 - Nov 29, 2016 at 11:23 AM
cody-peter Posts 2 Registration date Tuesday November 29, 2016 Status Member Last seen November 30, 2016 - Nov 29, 2016 at 11:23 AM
Related:
- Copy past using VBA
- Vba case like - Guide
- Number to words in excel formula without vba - Guide
- Vba check if value is in array - Guide
- Vba color index - Guide
- How to open vba in excel - Guide
3 responses
yg_be
Posts
23412
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
December 28, 2024
5
Nov 15, 2016 at 04:48 PM
Nov 15, 2016 at 04:48 PM
What error do you get when recording the macro?
yg_be
Posts
23412
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
December 28, 2024
5
Nov 15, 2016 at 05:31 PM
Nov 15, 2016 at 05:31 PM
Instead of prompting the user, the macro could perhaps print the currently selected row?
ntmn8r
Posts
3
Registration date
Sunday November 13, 2016
Status
Member
Last seen
November 17, 2016
Nov 17, 2016 at 02:33 PM
Nov 17, 2016 at 02:33 PM
YG_BE, Yes that would work. How do I get that to function?
yg_be
Posts
23412
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
December 28, 2024
5
Nov 17, 2016 at 02:42 PM
Nov 17, 2016 at 02:42 PM
If you want to learn how to do that :
1) start recording a macro
2) select a range you want to print
3) print the selection
4) stop recording the macro
5) examine the macro, and use it as an example to code what you want to achieve
1) start recording a macro
2) select a range you want to print
3) print the selection
4) stop recording the macro
5) examine the macro, and use it as an example to code what you want to achieve
cody-peter
Posts
2
Registration date
Tuesday November 29, 2016
Status
Member
Last seen
November 30, 2016
Nov 29, 2016 at 11:23 AM
Nov 29, 2016 at 11:23 AM
There are a few different ways to accomplish this task, and the macro recorder doesn’t always give you the most efficient VBA code.
In the following three videos I explain:
The most efficient method for a simple copy and paste in VBA.
The easiest way to paste values.
How to use the PasteSpecial method for other paste types.
In the following three videos I explain:
The most efficient method for a simple copy and paste in VBA.
The easiest way to paste values.
How to use the PasteSpecial method for other paste types.
Nov 15, 2016 at 05:11 PM
Now what I need is a way to prompt a user to input the row needed to print.
The some how in the code be able to take the input to assign a specific row
You help is greatly appreciated,