user29383902
New Member
- Joined
- Dec 6, 2024
- Messages
- 7
- Office Version
- Prefer Not To Say
- Platform
- Windows
I have a macro which works the way i want it to except for this part..
it returns y, instead of x in (x of y records found)
this happens after autofiltering with vba.
VBA Code:
Set rng = ws.UsedRange.Columns(1)
.Cells(r, "H") = rng.SpecialCells(xlCellTypeVisible).Count
it returns y, instead of x in (x of y records found)
this happens after autofiltering with vba.