Consulting

  • Categories Widget (Show All)

  • Recent Articles

  • Recent Forum Posts

    offthelip

    Bet Angel and Excel

    Hi Sam,
    Your "data array object" looks like it could be a very useful object for storing some of the intermediate values that don't need

    offthelip Today, 02:53 AM Go to last post
    Svmaxcel

    Get XLA file

    I searched a lot on internet to get good tweaks for excel.
    There are several excel addin available, but they are in .exe format
    Due to IT

    Svmaxcel Today, 02:02 AM Go to last post
    mana

    code optimization

    Sub test() 
         
         
        Range("E5:E303").Formula = "=VLOOKUP(C5&A5,plan_zmianowy!B:C,2,0)" 
        Range("I5:I303").Formula 
    
    
    Formatting tags added by mark007

    mana Today, 01:32 AM Go to last post
    rong3

    Help about dynamic value table array in Vlookup

    I help for other department that not allow to view file, So I build an Excel to get single value return of it.

    rong3 Yesterday, 09:26 PM Go to last post
    macropod

    Image Insertion and Auto Caption and Grouping

    The code in the link applies a 'Picture' caption to every image; that is what you cross-reference. All captions use SEQ fields, regardless of whether

    macropod Yesterday, 08:50 PM Go to last post