-
Hi
cur = thisworkbook.name
I am trying to insert this formula in another sheet [eg:B]. The VBA code is in another workbook [eg:cur which is user defined]. how do I make this sheet name dynamic?[name in bold in below formula]
ActiveCell.FormulaR1C1 = _
"=IF(ISblank(VLOOKUP(RC2,[cur]order!R2C1:R60C10,column(R4C)-3,0)),"""",VLOOKUP(RC2,[cur]order!R2C1:R60C10,column(R4C)-3,0))"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules