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

[Fiat77]

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?

 

[xlbo]

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

 

[Fiat77]

Could you give me the specific code and how to put it all together?

 

[xlbo]

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