Copying a dynamic row

[lpsmith]

Hi,

I would like to find out how to create a macro that will copy a set number of cells in a column no matter where the starting point is. For example I can copy 98 cells in column B starting at B2 or maybe starting at B34 or if I make G3 the active cell then when I run the Macro it will copy the next 98 cells below which ever cell I select.)

Thanks in advance for your help

L.Smith

 

[kmfna]

Hey bro,

I think you want to post this in the VBA forum. Common posters in there are more likely to have dealt with this.

Good luck,

Kevin

- "The truth hurts, maybe not as much as jumping on a bicycle with no seat, but it hurts.

 

[SkipVought]

L.Smith,

  range(activecell, activecell.offset(97,0)).copy

If you know the destination...

  range(activecell, activecell.offset(97,0)).copy Worksheets(2).[B1]

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244