topic Find first blank cell in a column in Excel in QlikView

Find first blank cell in a column in Excel

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Find first blank cell in a column in Excel

tamilarasu — Mon, 05 Feb 2018 12:08:08 GMT

Hi Mihai,

Please post your code here.

Re: Find first blank cell in a column in Excel

Anonymous — Mon, 05 Feb 2018 12:23:12 GMT

managed to find a solution on Google. Thanks for the help!