SelectionChange criteria

[BigDelGooner]

Hi there

I am having some difficulty working out how to activate the SelectionChange command if the user changes a cell in a particular column. Based on the fact that the column number may change the constant in this column will be that on row 7 the name will be "Fund Size".

Therefore my question is how do I get VBA to run my code if a user changes a cell in the "Fund Size" column...and underneath the "Fund Size" header (i.e. row 8 or greater).

Help greatly appreciated!

Cheers

 

[VoG]

Maybe like this

If Target.Column = Rows(7).Find(what:="Fund Size", lookat:=xlWhole, LookIn:=xlValues).Column Then

 

[BigDelGooner]

Thats great - thank you v much!

Have a good weekend!