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
same macro on multiple sheets
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Don Guillett, post: 6208198"] Correct for word wrap and fix the source range. For Each sh In Worksheets(Array("Verpand derde 9", "RVS Verp derde")) with sh .Range("AN2").FormulaR1C1 = _ "=VLOOKUP(RC[-1],Blad17!C[-39]:C[-38],2,false) .Range("AO2").FormulaR1C1 = _ "=VLOOKUP(RC[-2],Blad17!C[-40]:C[-38],3,false) 'etc .range("ao2:aU2").AutoFill Destination:=.Range("Ao2:Au200") next sh -- Don Guillett SalesAid Software [email]dguillett1@austin.rr.com[/email] [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
same macro on multiple sheets
Top
