Thanks for replying. A few questions about this.
I'll replace "sheet1" with the actual sheet name. I understand that.

Not sure about the 2nd line. Is the dot in front of range as in
(.range is this correct?
Also, what would mypovariable stand for? Would I replace this, too?
Not sure if all the components of this line are literal, or if I'm to
replace any of this.
Would the (e:e") part be replaced with the column letter I want it to
look at?

Thanks for your time.
J.O.