Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find method, after parameter (Excel 2000)

    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
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find method, after parameter (Excel 2000)

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

    after:=c
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •