Copy PasteSpecial Formulas from 1r x 10c rng to nr x 10c rng

[AlvaroSiza]

Can't seem to get passed this and I know it's easy.

lngRowInserts is a long variable holding the number of rows.

Data is in, say A2:P2 and is declared as DataRange as Range.

How do I copy DataRange and Paste Special as Formulas to the range of A3:PlngRowInserts?

My effort:

Please Login or Register  to view this content.

Thanks.

[smuzoen]

range of A3:PlngRowInserts

Do you want to copy a row of data to a Column i.e. Transpose the data. Your code supplied would take one row from A2:P2 and place it at A"n" where n = lngRowInserts i.e copy part of a row of data to a row lower down in the sheet. If you want to transpose it

Please Login or Register  to view this content.

The only reason you would use lngRowInserts would be to set the data range to copy - does the range extend over more than 1 row. I am not sure what you are trying to do exactly.

Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”

[AlvaroSiza]

I am trying to paste the formulas in A2:P2 down into A3:P194 (where 194 = lngRowInserts). I'm trying to programmatically highlight the source range and fill down.

[rscsmith]

Try this:

Please Login or Register  to view this content.

Cheers, Rob.

[AlvaroSiza]

Good ole Resize. Thanks Rob.