gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
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?
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?