VBA formulas

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA formulas

01-15-2016, 02:38 AM

Debaser

Windows 7 64bit VBA formulas

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

You need:

Code:

With Range("S2")
.Value2 = Application.Countif(Range("A:A"), "<>")
.numberformat = "#,##0"
End With

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Right and Len formulas together	PDGood	Excel	4	11-20-2015 06:50 AM
formulas	MSA5455	Excel	3	12-19-2014 01:50 AM
Help with IF or ELSE Formulas	tsaladyga	Excel	4	07-23-2014 09:04 AM
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 05:10 AM.