Excel VBA: Find out size of foreign lookup table

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 LOOKUP(RC5,lookup.xlsx!Item,lookup.xlsx!R2C:R559C) 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 Windows("lookup.xlsx").Activate last = Range("a65536").End(xlUp).Row Windows("whatever.xlsx").Activate but I'm not sure if there's a better way.

以上就是Excel VBA: Find out size of foreign lookup table的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准