VBA Code to apply to certain cells

[jaolvera]

How do I apply this code only to certain cells, not the whole worksheet

[#2]

@jaolvera 

In the line

Set xRgVal = Cells.SpecoalCells(xlCellTypeAllValidation)

change Cells to the range you want to limit it to, for example

Set xRgVal = Range("D2:D100").SpecoalCells(xlCellTypeAllValidation)

[#3]

Thank you! this error popped up when I go to enter data into the cells after@Hans Vogelaar 

[#4]

@jaolvera 

You forgot the quotes around the range address - see my previous reply for an example.

[#5]

I just added the quotes and the same error is populating

[#6]

nevermind it worked