Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    4
    Views
    47

    ..I suppose you could say I cheated a bit. ...

    ..I suppose you could say I cheated a bit.

    zeddy
    •Excel Station Outreach
  2. Replies
    4
    Views
    47

    Hi RG ..you can do it using conditional...

    Hi RG

    ..you can do it using conditional formatting.
    see attached example file.

    zeddy
    •Rebel Without Applause
  3. Replies
    1
    Views
    63

    Hi ..I didn't see the feedback??? ..but...

    Hi

    ..I didn't see the feedback???

    ..but here's the 2010 version, half the size of the 2003.
    Glad you liked it!
    ..any issues, post back here.

    zeddy
    •Fence Investigator
  4. Hi ..think of it like this, if C2 is 1st...

    Hi

    ..think of it like this, if C2 is 1st January then
    C2 - date(year(c2),1,1) would just give you 1st Jan - 1st Jan = zero
    ..so add +1 at end
    i.e. c2 - date(year(c2),1,1)+1 would give you 1...
  5. Hi Ferenc ..don't give up so easily! If you...

    Hi Ferenc

    ..don't give up so easily! If you want to use the keyboard only, then have a look at this attached version.

    This example allows you to use the keyboard to display the dropdown list...
  6. Hi ..try ALT ; or, if you are using an Apple...

    Hi

    ..try ALT ; or, if you are using an Apple ⌘⇧Z

    ..these are the shortcut keys for selecting visible cells only in the selection range

    zeddy
    •Large Animal Accounting Crew
    .
  7. Replies
    11
    Views
    670

    Hi Paul ..good spot on zFile - I changed it to...

    Hi Paul

    ..good spot on zFile - I changed it to zFilename in updated version attached.
    Your BubbleSrt is a useful method worth knowing.

    zeddy
    •Python Repair Depot
    .
  8. Hi Ferenc It is possible to show the dropdown...

    Hi Ferenc

    It is possible to show the dropdown list only when the User starts typing in an empty cell.
    However, this would require constant monitoring of the keys, and could affect performance....
  9. Replies
    11
    Views
    670

    Hi Paul Is there are more efficient way? ...

    Hi Paul



    Is there are more efficient way?

    zeddy
    •Coconut Husky Team Driver
    .
  10. Replies
    11
    Views
    670

    Hi Howard I've attached a file which will move...

    Hi Howard

    I've attached a file which will move matching files into a specified destination folder.
    As per your request, this will leave the most recent matching file in the source...
  11. Replies
    11
    Views
    670

    Hi Howard I need to create some dummy zip...

    Hi Howard

    I need to create some dummy zip files, then patch their date-timestamps, then create some test folders and subfolders to put them in, all this before I can test the code to do what you...
  12. Hi Ferenc You can change it to only show the...

    Hi Ferenc

    You can change it to only show the dropdown if the cell is empty.
    i.e. if the cell already has a value, do nothing.
    To make a change to an existing non-blank entry, you would then have...
  13. Hi Ferenc/RG ..OK, I made this example up with...

    Hi Ferenc/RG

    ..OK, I made this example up with approx. fifteen hundred entries in a list for the data validation dropdown list. I chose Cities for my example.
    In the attached file, a dropdown...
  14. Hi RG ..the Data Validation list will work,...

    Hi RG

    ..the Data Validation list will work, but can be tedious if there are a lot of entries in the validation list.
    It can mean lots of scrolling to get to your required entry.

    It is possible...
  15. Replies
    7
    Views
    306

    [SOLVED] Hi Rory ..thanks for clarifying that. It's...

    Hi Rory

    ..thanks for clarifying that.
    It's not the sort of thing I would do in vba - as you know, it is better to do Excel calculations on the worksheet itself if you can, rather than in vba.
    ...
  16. Replies
    7
    Views
    306

    [SOLVED] Hi Ferenc In addition to Rory's note, and to...

    Hi Ferenc

    In addition to Rory's note, and to further your goal of simplifying your code, you might consider using:


    With shtTrades
    set zCell = .cells(i,j)
    costTotal =...
  17. Replies
    7
    Views
    391

    [SOLVED] Hi RG ..Target.Offset(4 - r).Resize(5) etc...

    Hi RG



    ..Target.Offset(4 - r).Resize(5) etc etc etc

    ..it's efficient! it may be bad, but I liked it!
    ..and I mostly agree with everything you say!

    zeddy
  18. Replies
    7
    Views
    391

    [SOLVED] Hi Ferenc ..this might help: '- If all...

    Hi Ferenc

    ..this might help:


    '- If all Blank > Turn Seller name White
    '- If Sum of range > 0 Turn Seller name White
    ' - Else Keep Seller Name Black

    r = Target.Row
  19. Hi Howard ..try this code: Sub...

    Hi Howard

    ..try this code:


    Sub copyFilesToNewFolder() 'v1a zeddy

    Set fso = CreateObject("scripting.FileSystemObject") 'use late binding (doesn't need Reference...
  20. Hi Maud Thanks for your input. In my version,...

    Hi Maud

    Thanks for your input.
    In my version, I was using the fact that if you put the sheetname in a formula reference, changing the sheet name is supposed to trigger the calculate event. For...
  21. Thread: Simplifying VBA

    by zeddy
    Replies
    14
    Views
    715

    [SOLVED] Hi Ferenc ..you are making great progress with...

    Hi Ferenc

    ..you are making great progress with your coding!
    It's not too important to eliminate all steps, if it makes it easier to follow.
    So, although RG is correct in post#3, your post#2...
  22. ..what this means, for example, is if you change...

    ..what this means, for example, is if you change the tabname [5] to [5#], and then move the cellpointer on that sheet, it will be moved automatically and placed in sequential order with the other...
  23. Sorting Sheet Tabnames by group type, number and tab colour

    Hi all

    I've been having a look at automatic sorting of sheet tabnames when you make a change to a sheet tabname.
    (This was triggered after looking at some of Ferenc's files)

    As we know, there...
  24. Replies
    6
    Views
    282

    [SOLVED] Hi Ferenc I don't think it's as simple as...

    Hi Ferenc

    I don't think it's as simple as that. I am assuming you can't simultaneously have two tabnames like [+9] and [9@] at the same time.
    ..and you must be careful in vba that Sheet(7) is...
  25. Hi Howard ..why not have a go using previous...

    Hi Howard

    ..why not have a go using previous examples on this topic?
    If you get stuck, we can help you.
    The idea is that you learn from the stuff.
    ..we don't just want to do it all for you.
    ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4