Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello and happy holidays!
I'm making a macro to export some pivot tables from QlikView to Excel and at the moment I'm pasting them on excel ranges in a hard-coded trial-and-error manner. Is there any way to get the last row of a table you just pasted into Excel from QlikView, using VBA macros? I want to make the whole macro work more dynamically.
For example, assuming I have two tables(with ID "CH01"):
Employee_ID | Day | Hours worked |
---|---|---|
ChWb | 28/10/2017 | 8 |
pOD7 | 15/10/2017 | 8 |
TBKs | 22/11/2017 | 8 |
a6Ua | 18/11/2017 | 8 |
35PP | 02/12/2017 | 8 |
and(with ID "CH02")
Employee_ID | Hours worked/Month |
---|---|
ChWb | 160 |
pOD7 | 160 |
TBKs | 160 |
How should I write the VBA script so that the second table is pasted right below the first table, without hard-coding the range values?