Simple Macro

  • Thread starter Thread starter Nhoj.Nanyt
  • Start date Start date
N

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.
 
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.
Click to expand...

As ALWAYS, post your code for comments
 
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.
 
Back
Top