Can someone help me debug this piece of code?
.... Dim searchRng as Range With Sheets("Database") Set searchRng = Range("pointer.address:.cells(pointer.End(xlDown).Row,pointer.Column).address") End with
I keep getting error 1004: Method 'Range' of object '_Global' failed "pointer" is a previously defined range of one cell (B6). After various debugging attempts, the problem seems to be connected to .address... Thats as far as I've been able to trace it back.
Thanks in advance! Leo