Clear cell contents based on value of another cell range using VBA
Solved/Closed
Tbonekiller
Posts
15
Registration date
Wednesday August 21, 2019
Status
Member
Last seen
July 20, 2022
-
Jan 6, 2021 at 02:35 PM
Tbonekiller Posts 15 Registration date Wednesday August 21, 2019 Status Member Last seen July 20, 2022 - Jan 12, 2021 at 01:06 PM
Tbonekiller Posts 15 Registration date Wednesday August 21, 2019 Status Member Last seen July 20, 2022 - Jan 12, 2021 at 01:06 PM
Related:
- Excel clear cell contents based on condition
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel conditional formatting if cell contains specific text - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jan 12, 2021 at 11:59 AM
Jan 12, 2021 at 11:59 AM
Hi Tbonekiller,
Again that's an issue I'm not having, same with the brackets around the sheet names. I guess we have different VBA settings that I'm not aware of.
We can let Excel know to look at the whole cell. To do that, change:
into:
Does that solve it for you?
Now you know the power of VBA, it's quite the time saver.
Best regards,
Trowa
Again that's an issue I'm not having, same with the brackets around the sheet names. I guess we have different VBA settings that I'm not aware of.
We can let Excel know to look at the whole cell. To do that, change:
Set mFind = Range("K8:K38").Find(cell.Value)
into:
Set mFind = Range("K8:K38").Find(cell.Value, lookat:=xlWhole)
Does that solve it for you?
Now you know the power of VBA, it's quite the time saver.
Best regards,
Trowa
Jan 12, 2021 at 01:06 PM
PERFECT!!!!!! Thank you so much. This really helped me a lot.