Thread: [Solved] VBA formulas
View Single Post
 
Old 01-15-2016, 02:38 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
You need:
Code:
With Range("S2")
.Value2 = Application.Countif(Range("A:A"), "<>")
.numberformat = "#,##0"
End With
Reply With Quote