At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.
Sub Macro2() ' Sheets("CDPSRECRPT").Select Rows("1:1").Select Selection.AutoFilter ActiveWindow.LargeScroll ToRight:=1 ActiveSheet.UsedRange.AutoFilter Field:=16, Operator:= _ xlFilterValues, Criteria2:=Array(2, DateValue(Now)) 'Need to count how many visible cells the autofilter produced. Sheets("MOT-MeasureData").Select Rows("2:2").Select 'insert a row under headers. Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Rows("2:2").Select 'fix row height Selection.RowHeight = 14.4 Range("A2").Select ActiveCell.FormulaR1C1 = "=NOW()" Range("A2").Select Selection.NumberFormat = "m/d/yyyy" Range("B2").Select 'This is where I need to insert the value from above, total visible cells 'from autofilter End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.