Autofill Values Only
UtterAccess Discussion Forums
May 21 2012, 09:43 AM
Range("c3").AutoFill Destination:=Range("c3", ActiveCell), Type:=xlFillValues
this works well for the autofill, but the formulas don't break (i.e., turn into values)...?
May 21 2012, 10:04 AM
I'm sorry you can't do what you want just with AutoFill.
You need to copy the results of the formulas you've just created with the auto fill and use something like PasteSpecial to replace the formulas with values.
May 21 2012, 10:31 AM
ah...it sounded so nice...
So I added:
Range("a9:s9").AutoFill Destination:=Range("a9:s" & myrow), Type:=8
Range("a9", "s" & myrow).Copy
Range("a9", "s" & myrow).PasteSpecial xlPasteValues
Seems to be working…any thoughts? Thank you.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please