Worksheet 2 is blank accept for the formulas is Row A10 that refer to the
Data in row A2 in Worksheet 1.
I need to copy the formulas in Worksheet2 RowA10 to RowA11... Row??? so that
each row will reference a different row in Worksheet 2. In worksheet2, I
need to figure out a way to count the number of rows of data so I know how
many rows in Worksheet1 I need to copy RowA10 DOWN. Since the number of rows
in worksheet2 varies from month to month, I need a way of doing this without
having fixed ranges.

I hope this makes more sense.

Stopher wrote:
I'm assuming the formulas/values you are trying to copy from worksheet2
start at A10 and go down the page. You then want to copy these
formulas/values and paste them into Worksheet1.

If the data in worksheet2 is continous why not just do:

Range("A10").Select
Range(Selection, Selection.End(xlDown)).Select

This doesn't matter how long your data column is, as long as it is
continuos, ie no gaps. And then simply copy and paste into your
Worksheet2 as values or with formulas, how ever you want.

Is this of any help??

--
Message posted via http://www.officekb.com