Re: adapting the findnext function

LookIn:=xlValues, LookAt:=xlWhole


Lookin:=xlValues
says to look at what the formula produces and not at the formula itself.

Lookat:=xlWhole means the match must be to the whole value of the cell.
if you used xlpart, it would match "and" to "Sand" for example

--
Regards,
Tom Ogilvy

"chrisrowe_cr" <chrisrowe_cr.1t56yo_1122995160.4079@xxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:chrisrowe_cr.1t56yo_1122995160.4079@xxxxxxxxxxxxxxxxxxxxxxxx
>
> hmm,
>
> I tried this and woohoo it does work only it doesnt work...
>
> I figured out why tho, the values I want to format are all being pulled
> in via a lookup, is there anyway to make excel think they are just there
> and not part of a formula?
>
>
> --
> chrisrowe_cr
> ------------------------------------------------------------------------
> chrisrowe_cr's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25220
> View this thread: http://www.excelforum.com/showthread.php?threadid=392077
>


.

Relevant Pages

  • Re: working with IF statements
    ... I have some programming experience ... but not a whole lot with excel so this was just a thought. ... matty_g's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23954 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Converting Numbers to Time
    ... > why excel assumes that result of adding or subtracting two dates should ... mangesh_yadav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10470 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Autosave:: off
    ... FROM EXCEL AGAIN UNTIL YOU TURN IT BACK ON!* ... funkymonkUK ... funkymonkUK's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18135 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • To many rows for EXCEL to handle
    ... I have a file with over 70'000 rows in (MS EXCEL only holds around ... Is there any way I can still perform a lookup on this file. ... moglione1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26414 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • VLOOKUP being messed up by formating? Help..
    ... I'm trying to lookup Values of Column A in Query1 and match them ... However Excel 2000 seems to be unable to identify Query1!A4:A26 ... Dark_Templar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33279 ...
    (microsoft.public.excel.misc)