Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Find first blank cell in a column in Excel

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? 

2 Replies
Highlighted

Hi Mihai,

Please post your code here.

Highlighted
Creator II
Creator II

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