Set Target.Address to a Column

[Salrandin]

Hi All,

I am new here and from my recent lurkings have found my pathetic vision of excel to be shattered... I did not know you could do so much in it. Anyways I am looking to learn and my first question:

Is there a clean way to set target.address to a column?

If Target.Address = "$A$1" Then

I have googled some ways to set it to a defined range but I want a whole column. Any help appreciated. Thanks.

 

[Jonmo1]

sh is an object created by the workbook_sheetchange event...
It represents the Sheet that had some value on it changed.


I have been answering under the assumption that you're using a Worksheet_Change event code...since that where Target normally comes from...

 

[Salrandin]

sh is an object created by the workbook_sheetchange event...
It represents the Sheet that had some value on it changed.


I have been answering under the assumption that you're using a Worksheet_Change event code...since that where Target normally comes from...

Ahh okay it makes sense now... I am learning this through google examples on an as needed basis so there are wholes in my knowledge, thanks for the help.