VBA: If ActiveCell is not in range(d:d), go to cell D2

[kamelkid2]

every example i am finding on the internet is for way more complicated process and i cannot decipher the code that i need to use for this purpose, but what i am trying to do is have VBA select cell D2 if the activecell is not within the range D:D, otherwise leave the activecell alone.

could anyone please point me in the correct direction?

[kamelkid2]

Please Login or Register  to view this content.

it figures i am able to figure it out shortly after posting the question. in the 30 minutes i am trying to work on it independently i get nowhere but 5 seconds after i hit submit it comes to me

[Jakobshavn]

How about:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe these?

Please Login or Register  to view this content.