Find method, after parameter (Excel 2000)

Topic

New Reply

Hi,

I’m using the .find method and has noted that it takes an “after” parameter.
In the MS VBA help it says “After Optional Variant. The cell after which you want the search to begin. This corresponds to the position of the active cell when a search is done from the user interface. Note that After must be a single cell in the range…..”

If I make CellAddress = c.address and then use this as “after:=CellAddress”, then I recieve and error – how come ?
what I’m providing here is the cell address – or isn’t it ?
(I also tried 2 concatenations CellAddress = “Base_Clients!” & c.address …..and another version CellAddress = “=Base_Clients!” & c.address)

Still no luck….

Any suggestions ??

Thanks in advance,
Henrik

Reply | Quote

Replies

It is a range argument, so passing just c should be OK:

after:=c

Reply | Quote