Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
tamilarasu
Champion
Champion

Hi Mihai,

Please post your code here.

Anonymous
Not applicable
Author

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