I am writing an application in VBA to do simple subtotaling, completely independent of the subtotaling functions in excel.
I need a way to mark cells by manipulating a hidden property of some sort, so that the app sees these cells as subtotal cells. The marking needs to occur through the code, and needs to be invisible to the user. I can do it by bolding the text for example, but that is not elegant since a user could modify it. Any ideas?