Hi All,
Pls help me to modify the code with the following request
*1. Active cell - I should accept the active cell reference from the user n
the same varible will be very ever necessary.*
*ActiveCell*.FormulaR1C1 = _
"=VLOOKUP(RC[-6],'[SAMPLE
file.xls]PMSRegisterEC.rpt'!R11C2:R91C11,10,0)"
Range("I2").Select
Selection.Copy
Range("I3:I137").Select
ActiveSheet.Paste
I tried to change with a varible but in vain.
Hope to hear from you all.
Thanks n Regards,
Roshan
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
