Thread: Insert formulas in VBA code
View Single Post
 
Old 06-06-2015, 07:28 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
how 'bout this?
Code:
Range("D2").Formula = "=countif(E2:M2,""True"")"
Range("D2:D10").FillDown
Reply With Quote