Posted on 2014-04-13
This may seem like a bit of a silly question that I should have known by now...but I don't.
Now that I am combining lots of different code I am finding that I am getting tripped up quite a bit.
So for example:
Private Sub Worksheet_Change(ByVal Target As Range)
I know that this line (and the rest of the subsequent code) should probably go into a module. But how do I get the sub, once it is in a module, to point to the correct sheet?
This one above, I think, by default points to sheet1.
But how would I name this if sheet2 = BlueSheet or Sheet3 = RedSheet and I want to point to Bluesheet or Redsheet?
Sorry for the dumb Sunday AM question.