Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    8
    Views
    194

    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
  2. Replies
    11
    Views
    180

    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...
  3. Replies
    11
    Views
    180

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

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

    zeddy
  4. Replies
    8
    Views
    194

    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....
  5. Replies
    14
    Views
    256

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

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

    by zeddy
    Replies
    15
    Views
    376

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

    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...
  9. Replies
    25
    Views
    949

    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...
  10. Hi Maud Many thanks. Saving mouse clicks is...

    Hi Maud

    Many thanks.
    Saving mouse clicks is good.
    Excellent!

    zeddy
  11. Replies
    13
    Views
    280

    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
  12. 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...
  13. Replies
    25
    Views
    949

    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...
  14. 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
  15. 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...
  16. 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...
  17. Thread: office 2003

    by zeddy
    Replies
    7
    Views
    225

    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...
  18. Replies
    15
    Views
    1,296

    ..or you could also enter E2...

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

    zeddy
  19. Thread: formula help

    by zeddy
    Replies
    4
    Views
    172

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

    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...
  21. Replies
    7
    Views
    501

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

    Hi Howard

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

    zeddy
  22. Hi Steve Another way could be to use formulas...

    Hi Steve

    Another way could be to use formulas and Excel's camera tool.
    see example attached.

    zeddy
  23. Replies
    7
    Views
    501

    Hi Howard ..the flight was OK, but next day I...

    Hi Howard

    ..the flight was OK, but next day I was admitted to hospital again. Internal gunk removed. Still here. Nothing major. More ops to come.
    Apologies for delay.

    I have attached an...
  24. Hi Mattock12 ..welcome to the Lounge! You...

    Hi Mattock12

    ..welcome to the Lounge!

    You just need to adjust your formula to subtract 1 if there are any "No DT" in the range, so use this:

    ...
  25. Replies
    7
    Views
    501

    Hi Howard ..oops! I just attached what the...

    Hi Howard

    ..oops! I just attached what the newest file (but from the wrong folder!)
    I did it again.
    ..here it is.

    leaving shortly!

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