M
MJKelly
Hi,
I use the code below to copy formulas to additional cells. However, i
want to paste the copied formulas into multiple ranges instead of copy/
paste copy/paste etc. Can this be done?
Range("A1").copy Range("B1:B10")
I thought something like this but it doesnt work...
Range("A1").copy Range("B1:B10"), Range("F12:F45")
Any ideas?
Kind regards,
Matt
I use the code below to copy formulas to additional cells. However, i
want to paste the copied formulas into multiple ranges instead of copy/
paste copy/paste etc. Can this be done?
Range("A1").copy Range("B1:B10")
I thought something like this but it doesnt work...
Range("A1").copy Range("B1:B10"), Range("F12:F45")
Any ideas?
Kind regards,
Matt