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 Beginners
Use a cell value as part of a formula
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Leo Heuser, post: 3298176"] Chirag It's not clear to me, if you want the same formula in all cells. Is this, what you're after? Sub UpdateRef() Range("C2:V11").Formula = "=VLOOKUP($A2,'C:\Matrix0203\07-Feb03\[" & _ Range("A1").Value & "]Sheet1'!$A$1:$M$200,2,FALSE)" End Sub -- Best Regards Leo Heuser Followup to newsgroup only please. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Beginners
Use a cell value as part of a formula
Top
