Hello,
I am trying to figure out the following code in order
to update columns
please help me
Thanks
Oleg
If Cells(j, 9).Value = "" Then Cells(j, 9).FormulaR1C1 = "=IF(RC7=""N/A"",""N/A"",VLOOKUP(RC2,Details!C[-7]:C,8,0))" Cells(j, 9).Locked = True Cells(j, 9).FormulaHidden = True End If
Last edited by Paul_Hossler; 05-21-2020 at 08:54 AM. Reason: Reformat
You have not mentioned what your problem is?
If you're asking about the R1C1 reference style in the formula
https://www.excelfunctions.net/excel...ce-styles.html
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Posting Permissions
Reply With Quote
