Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    19
    Views
    7,585

    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
  2. 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
  3. Replies
    4
    Views
    107

    [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...
  4. Replies
    19
    Views
    7,585

    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...
  5. Replies
    19
    Views
    7,585

    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
  6. Replies
    7
    Views
    155

    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...
  7. Replies
    6
    Views
    210

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

    Also

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

    zeddy
  8. Replies
    7
    Views
    155

    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...
  9. Replies
    6
    Views
    210

    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...
  10. Replies
    9
    Views
    338

    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,...
  11. 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...
  12. 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...
  13. Replies
    19
    Views
    7,585

    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
  14. 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...
  15. 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...
  16. Replies
    3
    Views
    179

    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...
  17. Replies
    7
    Views
    261

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

    Hi Maud

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


    zeddy
  18. 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...
  19. ..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!
    ...
  20. ..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...
  21. message box automatic timeout

    Hi Howard

    Maud's suggestion will do as you ask i.e. 'the user does not even see the message box appear'

    There are occasions when you might want to have a message box automatically timed-out...
  22. Thread: If statement

    by zeddy
    Replies
    9
    Views
    263

    [SOLVED] Hi RG Further to Roy's post #3, you can also...

    Hi RG

    Further to Roy's post #3, you can also use
    {=IF(OR(A1=myList),"Home","")}

    entered as an array formula, where you have defined name myList referring to a block of cells containing the...
  23. Hi Herman A .pfa file is a printer font ascii...

    Hi Herman

    A .pfa file is a printer font ascii file. Did you mean a .pdf file?????

    zeddy
  24. Thread: Debugging code

    by zeddy
    Replies
    16
    Views
    566

    Hi RG I've learnt many things from you, so...

    Hi RG

    I've learnt many things from you, so it's nice to return the favour.
    ..and to all the others here in the Lounge.
    You know who you are!

    zeddy
  25. Replies
    10
    Views
    350

    Hi Mitch see kweavers formula in attached...

    Hi Mitch

    see kweavers formula in attached file.

    zeddy
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4