>This does appear to work, however, I'm not sure how to tell it what the range is since that will change based on the rownbr and should include the first AND second columns. Any suggestions. Thanks!
Can you construct your range in run-time?
Say, lcRange = "A1:A2"
If it's not broken, fix it until it is.
My Blog