Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having a macro in which I'm pasting some tables(1 per each sheet) from QlikView to Excel. Then I have to find the first blank row and paste some more tables underneath the first tables.I'm doing this statically, by hard-coding the ranges for every table, but I wanna make the whole macro more dynamically. How can I find the range for the first blank row in a column?
Hi Mihai,
Please post your code here.
managed to find a solution on Google. Thanks for the help!