ActiveCell question.

[gheyman]

What happens if you use your Ctrl key to select multiple cells? Can you have code that runs on the multiple selections? curious!

Lets say I have a List of Parts going down column B. And for each cell selected I wanted to add the formula:
ActiveCell.FormulaR1C1 = _
"=IFNA((XLOOKUP([@[Part List]],ModelGeneral_vluItem[ItemID],ModelGeneral_vluItem[ItemDescription])),"""")"

in column C for each "Selected" cell

Is that possible?

 

[Jeffrey Mahoney]

Please try this
Selection.FormulaR1C1 = "=IFNA((XLOOKUP([@[Part List]],ModelGeneral_vluItem[ItemID],ModelGeneral_vluItem[ItemDescription])),"""")"

 

[gheyman]

Thank you. I think you even answer my last post as well. THANKS!!