Re: VBA - vlookup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MoonWeazel (MoonWeazel.1cq4q8_at_excelforum-nospam.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 05:55:22 -0500

Hi Tom,

Thanks!! That works like an absolute treat!

You star!!!

Is there anyway to skip blank cells? Some of the items don't have a
dependency and the VB falls over.

Any help would be really really really appreciated!!!

TIA,

MoonWeazel 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: A critic of Guidos blog on Pythons lambda
    ... (also, not do the internal dependency tracking on, say, b if it happens to hold an immutable value (part of the Cells API). ... Each ruled Cell keeps track of its memoized value, datapulse stamp, and whether it in fact changed value in reaching its current datapulse stamp. ... This is a cascade of further notifications if anyone notified recomputes and in fact computes a different value. ...
    (comp.lang.python)
  • Ronald sez "A lot of whole aids are square and other fast businessmans are grumpy, but will Jim comm
    ... it lights a circle too worried on top of her absolute ... star. ... All monkeys will be latin flexible counts. ... therefore than strike with Roxanne's liquid variant. ...
    (sci.lang)
  • Re: Alternate row colouring that also works when sheet is filtered?
    ... Just tried this on a new worksheet but no luck. ... brand-new worksheet with absolutely no data, I selected cells A4 to ... changed the row colouring to light yellow, ... what I find funny is all the absolute cell ...
    (microsoft.public.excel)
  • Re: I never did this before...
    ... Cells created: 7000 ... 1200, a shocker, but 1000 are kludges to avoid insane dependency on the mouse position that is trivial to handle imperatively and another hundred are similarly multitudes of OS-event hooks used so not everyone ends up sitting there waiting on every click event. ... Intriguing histogram of length of dependency chain: ... probably 900 low-functionality input cells as an optimization trick. ...
    (comp.lang.lisp)
  • Re: Calculation speed and workbook size
    ... Excel sets aside some memory to maintain a dependency table - ... calculate cells that are dependent. ... On larger workbooks, however, if this table size is exceeded then ...
    (microsoft.public.excel.misc)