Hi all,
I am looking for a macro that lets me find the first ''empty'' cell in a table column. However, that exact same column contains functions that refer to another tab. Therefore a ''normal'' macro won't let me find that first empty cell, because I think it sees the function as ''something'' instead of nothing. The function in the cells is (='tab'!F16).
For some more info:
Tab is called ''RVO1''
The column I need to find an ''empty'' cell in starts at F12 and ends at F100001.
The table itself is called ''Table73''
Hope I gave you all the information needed.
I am looking for a macro that lets me find the first ''empty'' cell in a table column. However, that exact same column contains functions that refer to another tab. Therefore a ''normal'' macro won't let me find that first empty cell, because I think it sees the function as ''something'' instead of nothing. The function in the cells is (='tab'!F16).
For some more info:
Tab is called ''RVO1''
The column I need to find an ''empty'' cell in starts at F12 and ends at F100001.
The table itself is called ''Table73''
Hope I gave you all the information needed.
