Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Hi Maud ..I was just trying to get some...

    Hi Maud

    ..I was just trying to get some support for being able to post .xlsb files. Since 1.9MB -> 0.6MB is a big reduction in my book.
    Who can we ask to get .xlsb files posted here?????

    zeddy
  2. Replies
    13
    Views
    433

    Hi Maud Very good advice. Now, as my note...

    Hi Maud

    Very good advice.
    Now, as my note said, it assumes you have a sheet named [Links] in the workbook to be used for listing the workbook links. And, just to be sure, it makes sure that...
  3. Hi Maud ..the file would be a tiny bit smaller...

    Hi Maud

    ..the file would be a tiny bit smaller if you got rid of all the double-quote marks in column [B].
    And if we were allowed to post Excel files here in the lounge in Excel's .xlsb file...
  4. Hi Yes, it is possible. Let us have your...

    Hi

    Yes, it is possible.
    Let us have your sample.

    zeddy
  5. Replies
    13
    Views
    433

    Hi jkirk These routines may help. The first...

    Hi jkirk

    These routines may help.

    The first assumes you have a sheet named [Links] in your workbook.
    This is used to list the links.


    Sub listExcelLinks()
  6. Replies
    19
    Views
    7,774

    Hi Thank you for thanking me. Glad you were...

    Hi

    Thank you for thanking me.
    Glad you were able to tweak it for your needs.

    zeddy
  7. Hi Trevor Glad you resolved the issue. I...

    Hi Trevor

    Glad you resolved the issue.
    I presume you opted for the simplest solution of all, which is to tell your friend to get a 23" monitor.

    zeddy
  8. Replies
    4
    Views
    148

    [SOLVED] Hi Nicole If you used merged cells (with box...

    Hi Nicole

    If you used merged cells (with box outlines) for your spreadsheet 'form', then you can use data validation to display a message whenever the User clicks into that particular location. I...
  9. Replies
    19
    Views
    7,774

    Hi CJ5 Welcome to the Lounge with your first...

    Hi CJ5

    Welcome to the Lounge with your first posting.

    Yes, it is possible to specify the number of copies of each pdf file to print.
    However, Adobe reader doesn't have a command line switch to...
  10. Replies
    19
    Views
    7,774

    Hi Warna Have you tried to create a 'new...

    Hi Warna

    Have you tried to create a 'new printer' (with the settings you require) and then sending to that 'new printer'?

    zeddy
  11. Replies
    7
    Views
    190

    Hi Kevin As RG says (and I should have made...

    Hi Kevin

    As RG says (and I should have made this clear) you can save macros in .xlsb files.
    This is my default file format of choice.

    One reason you might NOT want to save as a .xlsb file is...
  12. Replies
    6
    Views
    244

    Also =TEXT(F2,"dddd mm/dd/yy ")&J2 zeddy

    Also

    =TEXT(F2,"dddd mm/dd/yy ")&J2

    zeddy
  13. Replies
    7
    Views
    190

    Hi Chris Your file is big, but well within...

    Hi Chris

    Your file is big, but well within limits for Excel.
    You don't say whether it is an .xls, xlsx, or .xlsm format.
    My advice is always to save in .xlsb format.
    If your file is not already...
  14. Replies
    6
    Views
    244

    Hi ..why waste time typing CONCATENATE when...

    Hi

    ..why waste time typing CONCATENATE when you can just use

    =TEXT(F2,"dd/mm/yyyy ")&J2

    Note: I have included the 'space' separator within the TEXT format to be used.
    For example, if you...
  15. Replies
    9
    Views
    383

    Hi Matt in my attached file, text on the sheet...

    Hi Matt

    in my attached file, text on the sheet will be searched for the text entry in cell [A1].
    The text will be highlighted with the colour of the text assigned in cell [A1].

    ..but note,...
  16. Hi Jim Thanks for your kind words. I'm...

    Hi Jim

    Thanks for your kind words.
    I'm currently packing for a trip to London, will be back mid next-week.
    If you haven't had any replies from others by then, I will do another update for you...
  17. Hi Mike Without using a macro, >> click the...

    Hi Mike

    Without using a macro,
    >> click the column heading that contains the data (to highlight the entire column), then
    >> press Ctrl-H (this brings up the Excel 'Find and Replace' dialog...
  18. Replies
    19
    Views
    7,774

    Hi Warna Welcome to the lounge. What sort of...

    Hi Warna

    Welcome to the lounge.
    What sort of settings are you trying to change?
    Paper size??

    zeddy
  19. Hi Jim In the attached file, the source data...

    Hi Jim

    In the attached file, the source data sheet is named [data]
    (if you want to rename this sheet, don't have any spaces in the sheet name)
    There are no macros in the file, we just use...
  20. Hi RG We should always pay attention when rory...

    Hi RG

    We should always pay attention when rory has something to say.

    So just in case, I've added an updated file which also includes a Form method.
    The advantage of using a Form is you can do...
  21. Replies
    3
    Views
    184

    Hi Carmine ..how about attaching some sample...

    Hi Carmine

    ..how about attaching some sample dummy text files that approximate to what you have?
    That way, we could more easily give you some code to do what you want.
    How do you want the sheets...
  22. Replies
    7
    Views
    267

    Hi Maud ..maybe he needs to use Excel's...

    Hi Maud

    ..maybe he needs to use Excel's scenario manager???


    zeddy
  23. Hi RG Although it didn't seem to make much...

    Hi RG

    Although it didn't seem to make much difference in timing in this particular case, Early Binding is supposed to be a little faster. Early Binding also gives you the availability of...
  24. ..and the advantage of the Excel2013 version is...

    ..and the advantage of the Excel2013 version is it is so much easier to have the two windows on adjacent screens i.e. if you aren't working with two screens you should really get a second one now!
    ...
  25. ..and in Excel2013, if you do want the two...

    ..and in Excel2013, if you do want the two windows to scroll synchronously, in the [Windows] group in the top-panel ribbon, simply click the option View Side by Side and then click the option...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4