Simple Macro
 

Hi all,

I have a basic script that loops through a range of data to copy and
paste into the front end of some calcs, then goes and copies the
results to a compilation sheet.

I have the navigation sorted, just using offset to get to the column
of data I want.

I can get the cursor where I want it, but I can't nut out how to
select a range of 8 cells under where the cursor ends up, copy and
paste into inputs.

Please help!
Cheers,
John.

Simple Macro
 

On Dec 18, 8:37*pm, "Nhoj.Nanyt" wrote:
Hi all,

I have a basic script that loops through a range of data to copy and
paste into the front end of some calcs, then goes and copies the
results to a compilation sheet.

I have the navigation sorted, just using offset to get to the column
of data I want.

I can get the cursor where I want it, but I can't nut out how to
select a range of 8 cells under where the cursor ends up, copy and
paste into inputs.

Please help!
Cheers,
John.

As ALWAYS, post your code for comments

Simple Macro
 

Hi John,

Its rarely necessary to select the data you're manipulating but maybe
this will get you moving in the right direction...

Activecell.Resize(8,1).Select

or better still, something along these lines after declaring and
setting rngDestination...

Activecell.Resize(8,1).copy rngDestination

Br, Nick.