I have three tables in three sheets and I would like to put this formula after the table directly at the last column of it
Code: Select all
=SUBTOTAL(109,HR_2[Total])
I tried something like that but got an error
Code: Select all
.Range("AH" & p + 1).Formula = "=SUBTOTAL(109," & .ListObjects(1).Name & "[Total])"
The thread posted here too
https://www.excelforum.com/excel-progra ... ost5042490" onclick="window.open(this.href);return false;