Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Thread: If statement

    by zeddy
    Replies
    9
    Views
    161

    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...
  2. 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
  3. Thread: Debugging code

    by zeddy
    Replies
    16
    Views
    468

    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
  4. Replies
    10
    Views
    211

    Hi Mitch see kweavers formula in attached...

    Hi Mitch

    see kweavers formula in attached file.

    zeddy
  5. Replies
    12
    Views
    354

    Me neither. I can't even figure out what it's...

    Me neither.
    I can't even figure out what it's used for either.

    zeddy
  6. Replies
    11
    Views
    289

    Hi As a different approach, it is possible to...

    Hi

    As a different approach, it is possible to use Excel's DMAX function to return the maximum value from a specified column, in a specified data block, that meets specified conditions.

    In the...
  7. Replies
    11
    Views
    289

    It's unclear to me too. Let's have another...

    It's unclear to me too.
    Let's have another sample file.

    zeddy
  8. Replies
    12
    Views
    354

    Aha! Maud, you fell into the trap. Another...

    Aha!
    Maud, you fell into the trap.

    Another way is to delete the line..
    Dim I As Integer, J As Integer
    ..completely!
    And then it will work. And the code is shorter.

    RG: I rest my case again....
  9. Replies
    21
    Views
    359

    Hi Rory ..your wise man advice is the best...

    Hi Rory

    ..your wise man advice is the best I've seen on this site. I am preparing to move house now.

    re post #2
    RG - I was once caught out in vba by assuming the last opened Excel file was the...
  10. Replies
    16
    Views
    448

    Hi Copy the attached files to a test folder of...

    Hi

    Copy the attached files to a test folder of your choice.

    In the attached macro .xlsm file, I have deleted the sheet [19] to show how a new sheet will be created if it doesn't exist.
    Click...
  11. Thread: Debugging code

    by zeddy
    Replies
    16
    Views
    468

    Hi Following on from RG's post#8, in the vba...

    Hi

    Following on from RG's post#8, in the vba Tools>Options click on the [General] tab and set the Error Trapping option to
    'Break in Class Module'.
    This should be the default setting in my...
  12. Replies
    6
    Views
    580

    Hi I'm not sure if I understand your question,...

    Hi

    I'm not sure if I understand your question, but a formula in say, cell [D1] , to return the last entry in a column could be as simple as:
    =INDEX(B:B,COUNTA(B:B))
    ..which will return the last...
  13. Replies
    25
    Views
    992

    When you do a 'File-Open' from within Excel, it...

    When you do a 'File-Open' from within Excel, it will default to browse in your 'current' folder. You may also have network drives assigned (which can 'shorten' the full filename spec), so this is NOT...
  14. Hi Maud Many thanks. Saving mouse clicks is...

    Hi Maud

    Many thanks.
    Saving mouse clicks is good.
    Excellent!

    zeddy
  15. Replies
    13
    Views
    347

    Hi I found one of the best ways to learn...

    Hi

    I found one of the best ways to learn macros was to look at macros that had been done by others ahead of me.

    I still find this a useful method.

    zeddy
  16. Hi Maud ..but there are thousands and...

    Hi Maud

    ..but there are thousands and thousands and thousands of colours to choose from.
    Not counting Theme colours etc.
    So rather than let the User be restricted to any 'pre-defined' colours on...
  17. Replies
    25
    Views
    992

    Hi ..what type of Excel files are you trying...

    Hi

    ..what type of Excel files are you trying to open via Windows Explorer?
    Are they password-protected files?
    Are they .xlsm or .xlsb files?
    Are they 'big' files or 'small' files?

    Rory said...
  18. Hi All I have attached a sample file (based on...

    Hi All

    I have attached a sample file (based on Maud's file - many thanks for that again!) to show you the method I used.

    zeddy
  19. Hi RG and Maud Many thanks for your help on...

    Hi RG and Maud

    Many thanks for your help on this, apologies for delay in responding.
    Both of your methods were excellent, and I am very grateful for your quick response to my request.

    As it...
  20. fast vba method to set background colour for record rows by Country

    Hi

    Using Excel2013 (or Excel2010):

    I have an entirely blank row9.
    I have a headings row, in row10, range [a10:z10]
    I have a block of data, in cells [a11:z3000]

    The heading in [K10] is...
  21. Thread: office 2003

    by zeddy
    Replies
    7
    Views
    254

    Hi I have four versions of Office installed on...

    Hi

    I have four versions of Office installed on my laptop.
    I don't have any problems.
    Latest versions of Office install allows you the choice to 'keep' previous versions, if you wish. (You can...
  22. Replies
    15
    Views
    1,319

    ..or you could also enter E2...

    ..or you could also enter
    E2 =IF(MIN(C2,D2)>3,"Bonus","")
    ..and copy down

    zeddy
  23. Thread: formula help

    by zeddy
    Replies
    4
    Views
    190

    Hi Another way is to use this custom format on...

    Hi

    Another way is to use this custom format on the column:
    mm"/1/2014"

    This will keep the start date value, but will display it as the Anniversary date.

    zeddy
  24. Replies
    6
    Views
    325

    Hi RG/Arcturus You don't need to use Access. ...

    Hi RG/Arcturus

    You don't need to use Access.

    I opened the file, and created a simple pivot table on an empty sheet.
    I used entire Column [B] Account# as my data source.
    I chose Account# as my...
  25. Replies
    7
    Views
    502

    Hi Howard ..now back at home. Did you check...

    Hi Howard

    ..now back at home.
    Did you check previous posting out?

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