I have an Excel VBA sub that (among other things) pastes a lookup formula into some cells. The lookup formula is presently of the form
but the size of the lookup table will change. Is there a good way to find the size of the lookup table, that is, the last row?
In a pinch I suppose I could open the lookup file (what's the command for that?) and do
last = Range("a65536").End(xlUp).Row
but I'm not sure if there's a better way.
以上就是Excel VBA: Find out size of foreign lookup table的详细内容，更多请关注web前端其它相关文章！