Insert formulas in VBA code

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Insert formulas in VBA code

06-06-2015, 07:28 AM

NoSparks

Windows 7 64bit Insert formulas in VBA code

Office 2010 32bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

how 'bout this?

Code:

Range("D2").Formula = "=countif(E2:M2,""True"")"
Range("D2:D10").FillDown

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code for Microsoft Word macro — select text and insert footnote	ndnd	Word VBA	10	01-06-2015 01:47 PM
Help with IF or ELSE Formulas	tsaladyga	Excel	4	07-23-2014 09:04 AM
Search and replace/insert HTML code into Master File using tags	dave8555	Excel	2	02-23-2014 03:51 PM
Need help with formulas please	paul_pearson	Excel	0	03-20-2013 06:51 AM
IF Formulas	mizzamzz	Excel	1	07-08-2010 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 AM.