Hi,
I intend to trigger from Personal Macro Workbook by a custom button in QAT.
Act upon an ActiveCell.
Active cell is going to be in a Header Row of a spreadsheet. Header Row can be in any row, not necessarily in row one. ActiveCell in any column.
Need VBA to adopt the below formula, such that:
I intend to trigger from Personal Macro Workbook by a custom button in QAT.
Act upon an ActiveCell.
Active cell is going to be in a Header Row of a spreadsheet. Header Row can be in any row, not necessarily in row one. ActiveCell in any column.
Need VBA to adopt the below formula, such that:
- "XX" in it would be replaced by the existing content of the ActiveCell
- "A4" in it would be replaced by the Column letter of the ActiveCell and a row number below the ActiveCell
- Letter in "A1000000" in it would be replaced by the Column letter of the ActiveCell
Excel Formula:
="XX. Tot: " & COUNTA(A4:A1000000) & " Vis: " & AGGREGATE(3,3,A4:A1000000)