Quote Originally Posted by Codeblue
thanks for the input.
This is partially working, it is working for column C only.
Isn't that because your activecell is in column C and you use the column of the activecell?