This code displays the sum of two worksheet columns in my UserForm Textbox.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
<o></o>
<o></o>
How can I code Textbox13 to display the SUBTOTAL of these columns when the sheet is AutoFiltered?<o></o>
<o></o>
Code:
[FONT=Verdana]TextBox12.Value = Format(Application.Sum(Sheet1.Range("T:T")) + Application.Sum(Sheet1.Range("U:U")) / 4, "$ #.00")[/FONT]
<o></o>
How can I code Textbox13 to display the SUBTOTAL of these columns when the sheet is AutoFiltered?<o></o>