Code not working
You just need to modify the range you are searching. Change...
Set rngToSearch = wksCopyFrom.Columns(2)
to
Set rngToSearch = range(wksCopyFrom.Range("B3", _
wksCopyfrom.Range("B65536").end(xlUp))
Or something like that (untested)
--
HTH...
Jim Thomlinson
"GregR" wrote:
Jim, I need to exclude row 1 and 2 (header rows) from the "CopyFrom"
range. TIA
Greg
|