Incrementing Rows in columns
Ray,
I'm not sure I quite understand what you're getting at, but have you thought
of creating names in your worksheet, then referencing the names in your code,
as against cell addresses?
This means that if the ranges (e.g. a1:10) are moved (to B15:B24 for
example), or have rows inserted into them (making your range a1:a12, for
example) or deleted from them, the code will still work on the range of cells
to which the nam applies. This is because names follow the cell ranges and
reflect whether they've moved, or grown/shrunk.
Sorry to be dim,. but toes this help at all with what you're trying to do?
Regards
Pete
"Ray via OfficeKB.com" wrote:
I am trying to set up a macros that will increment the referenced row as the
columns are dragged down. The only problem is that I want the rows to remain
steadfast so that I can then drag them across the page without having them
increment. How can I do that? Hopefully this will give you an example:
In A20:
=sum($a$1:$a$10)*sum(a$1:a$10)
Then in B20:
=sum($a$1:$a$10)*sum(b$1:b$10)
And C20:
=sum($a$1:$a$10)*sum(c$1:c$10)
But in A21:
=sum($b$1:$b$10)*sum(a$1:a$10)
And in B21:
=sum($b$1:$b$10)*sum(b$1:b$10)
and c21:
=sum($b$1:$b$10)*sum(c$1:c$10)
It would be really nice to be able to drag this and make it work, and/or
write macros to do it rather than doing it by hand.
Thanks a TON!!!
|