copy/paste macro

External Since: Dec 31, 2009 Posts: 1

I am trying to create a macro that will copy a range of data; however, the
number of rows to copy will vary each time the macro is run. Is there a way
that I could creat parameter fields that the macro cuold read?

Thanks,
Micki

External Since: Jan 5, 2009 Posts: 2

Micki
You need to come up with some way for the code to determine the range to
copy, and that depends on the nature of your data. For instance, let's say
that Column A has data from row 2 to the last row of your data and your data
is 6 columns wide. The copy command would look like:
Range("A2", Range("A" & Rows.Count).End(xlUp)).Resize(,6).Copy
Come back if you need more. HTH Otto

"Micki" wrote in message

> I am trying to create a macro that will copy a range of data; however, the
> number of rows to copy will vary each time the macro is run. Is there a
> way
> that I could creat parameter fields that the macro cuold read?
>
> Thanks,
> Micki