Forum Discussion

jaolvera's avatar
jaolvera
Brass Contributor
Aug 16, 2023

VBA Code to apply to certain cells

How do I apply this code only to certain cells, not the whole worksheet  
Macros and VBA
jaolvera's avatar
jaolvera
Brass Contributor
Aug 16, 2023

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

 

HansVogelaar's avatar
HansVogelaar
MVP
Aug 16, 2023

jaolvera 

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

  • jaolvera's avatar
    jaolvera
    Brass Contributor
    Aug 16, 2023
    I just added the quotes and the same error is populating
    • jaolvera's avatar
      jaolvera
      Brass Contributor
      Aug 16, 2023
      nevermind it worked

Resources