VBA Code to apply to certain cells

Question

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

hansvogelaar · Answer

jaolvera&nbsp;
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)

jaolvera · Answer

Thank you! this error popped up when I go to enter data into the cells afterHansVogelaar&nbsp;&nbsp;

hansvogelaar · Answer

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

jaolvera · Answer

I just added the quotes and the same error is populating

jaolvera · Answer

nevermind it worked

Forum Discussion

VBA Code to apply to certain cells

5 Replies

Resources