How to check whether subtotals are on a worksheet

  • Thread starter Thread starter AlanAylett
  • Start date Start date
A

AlanAylett

Hi,

does anybody know a way of checking whether subtotals have been added
to a worksheet using a macro??

Cheers, Alan
 
How about just looking for "=subtotal("?

Record a macro when you do it manually (edit|find)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy within a subtotal 1
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
subtotal within subtotal 5
Macro To Remove Subtotals from ALL Worksheets 3
SUBTOTAL 2 WORKSHEETS 6
Subtotal/Consolidate/Pivot Table, Lookup ??? 2
Subtotal To Include Item Description On Subtotal Line 2

Back
Top