Quality, Affordable & Flexible
Take advantage of our Microsoft Office Series public courses’ Buy 2 Get 1 FREE package!!
When you have selected a range, it is sometimes useful to know how many rows or columns you have selected as this information can be used in your macros (for eg when you have reached the end, you will know it is time to stop the macros. This macro will do the trick.
myCount = Selection.Rows.Count 'Change Rows to Columns to count columns
The next macro counts the number of sheets instead.
myCount = Application.Sheets.Count