CODEWITHSUNDEEP
excelexcel-2003vba
BioXhazard
BioXhazard

Reputation: 518

Excel, specify certain cell using Name field

I created a macro that doesn't allow values in both the B and C columns of an Excel sheet. I want to make an exception to that formula by allowing cells with the names DayShift or AfterShift.

I created this:

If ActiveCell.Name = "DayShift" Or ActiveCell.Name = "AfterShift" Then

But it doesn't seem to work and just makes other cells error. Does anyone know how to do this correctly?

Upvotes: 0

Views: 110

Answers (1)

Trefex
Trefex

Reputation: 2320

Try this:

If ActiveCell.Name.Name = "DayShift" Or ActiveCell.Name.Name = "AfterShift" Then

Upvotes: 1

Related Questions