Excel VBA Updating existing text label
Posted on 2007-03-26
I'm attempting to update a text label with a subtotal formula. I'd like to do it without relying on VBA, but I'll take what I can get. Subtotal will update anytime an autofilter criteria is changed, so I'd like to rely on that to change my label, but I can figure out how to do it outside a procedure, which follows:
Application.ScreenUpdating = False
.Caption = Range("D6").Text
Application.ScreenUpdating = True
Thanks for any suggestions!