Re: jump to linked cell

hi, Chriske !

> ... I get an error going thru the code
> "Object doesn't support this property or method (Error 438)"
> this happens when setting ncol equal to evaluate(left(tmp,len(tmp)-1))
> I changed this to isnumeric cause I think that was your intention
> then I get a type.mismatch on using application.match
> that I haven't figured out yet
> could you help me further along?
> I work with Excel 2003

I used the same formula [and variations] as in your example: -> =VLOOKUP($B$1;vacancies;21)
the 4th argument [false/true] for an un/sorted range is NOT used
made some changes in the column_number [21] to be taken from another cell [i.e. -> $A$1]
so [I guess] the evaluate method is needed in order to properly 'convert' 3rd argument to a number/column ;)

I couldn't 'reproduce' the 438 error you are getting -?-
neither the type.mismatch on application.match -?-
tests running in xl97 -> xl2003

is there any chance of difference regarding the assumptions and 'the real' formula you are using ?

regards,
hector.


.

Relevant Pages

  • vs2003 to vs2005
    ... get a chance to automatically upgrade? ... Regards ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Offline Files
    ... Is yours Windows XP home edition by any chance? ... Regards, ... Dinesh ... Prev by Date: ...
    (microsoft.public.windowsxp.network_web)
  • Re: Can I get Keyboard data not using Controls?
    ... and i appreciate your feed-back. ... hector. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Offline Files
    ... Is yours Windows XP home edition by any chance? ... Regards, ... Dinesh ... Prev by Date: ...
    (microsoft.public.windowsxp.network_web)
  • Nearing end of o2 contract
    ... Had a missed call on my phone today, I called back when I had the chance and ... Regards, ... Tony. ... Prev by Date: ...
    (uk.telecom.mobile)