Simple Macro

[Nhoj.Nanyt]

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.

 

[Don Guillett Excel MVP]

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

 

[Nick H]

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.