Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Macro to Copy a Specific #of Rows and Columns Using Offset

Status
Not open for further replies.

Fiat77

Programmer
Feb 4, 2005
63
US
I need a Macro that wherever my cursor is in any cell on a workbook that it goes and copies exactly 370 Rows down and 23 columns over from my Active cell's position. How can i do this?
 
ERm - you kinda answered the question yourself. All your keywords are there. Look in the help files for:

Activecell
Offset
Copy

Post back with a specific question if you have any problems with them

Rgds, Geoff

Don't let DPlank beam me up again Ascotta - I want my clothes to be kept on this time

Please read FAQ222-2244 before you ask a question
 
Could you give me the specific code and how to put it all together?
 
nope - that's what the help files and your mind are for - would you like me to take some of your pay packet as well if I'm going to do your work for you ??

Have you looked in the help files at the offset function ? Do so and if there is something you don't understand, post back with a specific question.

This site is about learning NOT just giving out answers.

Rgds, Geoff

Don't let DPlank beam me up again Ascotta - I want my clothes to be kept on this time

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top