N
norman
Hello Karen.
I might be missing something, but if you 'select' 1:1,
then use 'selection' in a formula, it starts with the
cell selected (1:1) not the one activated.
The following code will hunt back from the end (or
whatever parameter you use) to the last row in a range.
Set rngZipCodes = Range(Range("a2"), Range("a65536").End
(xlUp)).
Just substitute A2 for N1 and a65536 for a row beyond the
end of the range.
Norman
I might be missing something, but if you 'select' 1:1,
then use 'selection' in a formula, it starts with the
cell selected (1:1) not the one activated.
The following code will hunt back from the end (or
whatever parameter you use) to the last row in a range.
Set rngZipCodes = Range(Range("a2"), Range("a65536").End
(xlUp)).
Just substitute A2 for N1 and a65536 for a row beyond the
end of the range.
Norman