Sir Babydum GBE
06-09-2015, 01:00 AM
Hello, nice to be back...
i want to use VBA to fill formulas in an opposite direction. That's really badly put, so I'll try again.
suppose I decide to input in A1 "=c1000*2"
now if I copy down to A2, my formula will be =C1001*2
but I want it to read =C999*2, and A3 =C998*2, and so on
so basically I'm looking for VBA to look at the row reference in A1 then copy down to (in this example) A1000 until the macro realises its at =C1*2 and then stop.
is this possible?
Thanks in advance
i want to use VBA to fill formulas in an opposite direction. That's really badly put, so I'll try again.
suppose I decide to input in A1 "=c1000*2"
now if I copy down to A2, my formula will be =C1001*2
but I want it to read =C999*2, and A3 =C998*2, and so on
so basically I'm looking for VBA to look at the row reference in A1 then copy down to (in this example) A1000 until the macro realises its at =C1*2 and then stop.
is this possible?
Thanks in advance