Search:

Type: Posts; User: GeneO; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    452

    Re: Not showing pictures (6)

    By sheer coincidence, I too, was just having this problem when I came here to see if there was anything regarding this in the Lounge. My homepage (msn.com) and the Lounge pages and others were...
  2. Re: Upgrade recommendation for NS 4.04 (NS 4.04)

    I appreciate your feedback. But, the 4.7x versions seem to go from 4.7 to 4.79. Should I just assume the highest number is 'best' and go for 4.79 or are there issues that would make one of the...
  3. Upgrade recommendation for NS 4.04 (NS 4.04)

    My wife has been using NS 4.04 for a couple of years. She is heavily dependent on the e-mail functions and uses that a lot. I'd like to get her a little more current (I use IE on the same machine...
  4. Re: Preset the folder in SHBrowseForFolder API (Excel 8 SR-2 VBA)

    No - I'm not using the FileOpen or GetSaveAsFileName functions because I only want to put up a 'Choose Folder' function and both of those built in dialogs have unwanted side effects.

    Charlotte, in...
  5. Preset the folder in SHBrowseForFolder API (Excel 8 SR-2 VBA)

    I'm using the SHBrowseForFolder API to get a Folder choice from the user using a construction similar to the snippet below. There are a couple of examples floating around the web...
  6. Thread: Need a Scanner

    by GeneO
    Replies
    11
    Views
    616

    Re: Need a Scanner

    It depends on your definition of 'High End'. If you need to scan several thousand pages each day, Gary is right in recommending a vendor like Kodak that makes products for this market. If you...
  7. Replies
    2
    Views
    328

    Re: Calculating Pre-1900 Dates

    John Walkenbach has this download for handling dates prior to 1900 on his site:
    <A target="_blank"...
  8. Re: using Match & Index Functions alone & together

    >Oh , I still want to know "what should MATCH(A1,B3:G5,0)) ->- had a typo in my 1st posting -- return?".

    Apparently, #N/A

    Although the Help says:

    Lookup_array is a contiguous range of...
  9. Re: using Match & Index Functions alone & together

    The only way the Index example will work, is if you select the number of cells = to the number of expected returned values (in this case two) and array enter the formula in this range. It returns 2...
  10. Replies
    10
    Views
    711

    Re: Formuli on filtered data

    Because the topic was regarding 'filtered' data. See the below excerpt from the Excel 8 Help on Subtotal:


    SUBTOTAL will ignore any hidden rows that result from a list being filtered. This is...
  11. Replies
    4
    Views
    1,182

    [SOLVED] Re: blank spreadsheet

    Maybe it really is blank...
    Using Excel 8 SR-2 (Office97), if I save a new workbook with no entries (using 3 worksheets as the default for a new workbook), the file size is 14K. Saving a new...
  12. Replies
    5
    Views
    9,508

    [SOLVED] Re: Increase/Decrease Indent

    There are increase and decrease indent buttons on the formatting toolbar. If you want to use short-cut keys, you'll need to write a short sub-routine that changes the IndentLevel Property of your...
  13. Replies
    4
    Views
    672

    Re: Excel 2K - Formula too long msg

    <P ID="edit"><FONT SIZE=-1>Edited by GeneO on 01/03/21 23:03.</FONT></P>I did some testing and on my installation of Excel 8 SR-2, the limit seems to be 1024 characters in a Formula.

    Can anyone...
  14. Replies
    4
    Views
    672

    Re: Excel 2K - Formula too long msg

    Presumably... The people describing their problem to me are in a different location and I haven't been able to see this directly. I just did a short test on my own machine, and I have formulas,...
  15. Replies
    4
    Views
    672

    Excel 2K - Formula too long msg

    I work in an environment where we build financial model sets that involve many workbooks. Some of my peers, since installing Office 2K, have been complaining that, when they build a formula that...
  16. Replies
    9
    Views
    661

    Re: excel headers and footers

    It sounds as if you only set-up your desired header/footer on one sheet. If you want the same thing on multiple sheets, do a Group select (select left most sheet, hold down Shift key and select...
  17. Replies
    2
    Views
    655

    Re: Printing multiple ranges on one page

    Another way is to 'paste pictures' of your dispersed ranges onto one sheet arranged in the way you want to see the printout. Check Excel Help for "Pictures" and check the topic titled: "Create a...
  18. Replies
    8
    Views
    441

    Re: Excel PageFormatting Macro

    Another suggestion...

    The Print drivers being used may make a big difference. Are the slow machines using a different printer?
  19. Replies
    8
    Views
    688

    Re: In-Cell Dropdown Box

    On the Settings tab for the Data Validation box is a check option to "Ignore blank" which allows blank entries in the cell.
  20. Replies
    11
    Views
    977

    Re: Delete Invisible Macro

    Well done. All I can say is:
    You gotta love the M$ office products... <img src=/S/frown.gif border=0 width=15 height=15>
  21. Replies
    11
    Views
    977

    Re: Delete Invisible Macro

    This can happen it the 'Names' were referring to old EXCEL4 functions like GET.DOCUMENT for example.
  22. Replies
    4
    Views
    507

    Re: Referring to named ranges

    I think that's the safest bet, but I haven't researched it thoroughly.
  23. Replies
    4
    Views
    507

    Re: Referring to named ranges

    I think your last supposition is the culprit (range not on the active sheet), but there are a couple more implications:

    Range names can be defined at the workbook level (VBA code should run as...
  24. Replies
    8
    Views
    886

    Re: Excel 97 External Remote References

    Examine your 'copied' sheet for named ranges which have references to external sources. Also, charts, buttons, and other objects may have external links as well.
  25. Replies
    3
    Views
    2,368

    Re: When to use array formulas?

    True, you can't insert rows in the middle of the array, but there are cases where array formulas are invaluable. For example, I often have to use a 'SumProductIF' construct to calculate average...
Results 1 to 25 of 113
Page 1 of 5 1 2 3 4