Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
using vlookup in vba
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Claus Busch, post: 7414161"] Hi, Am Thu, 7 Feb 2013 10:52:36 +0100 schrieb Claus Busch: if you want to suit the references in every new row: With Sheets("Sheet1") .Range("B1").Formula = "=VLOOKUP(C1,'ILK1'!C2:C54,ROW(A1),0)" .Range("B1").AutoFill .Range("B1:B10") End With Regards Claus Busch [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
using vlookup in vba
Top
