Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Search entire column data in a another column

    will there be any blanks in column c?
    and what about column a?
  2. Re: Help with totaling up currency for a game

    try this?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  3. Re: Someone else is using the file. Please try again later.

    using an event like workbook_open
    So if you paste the event code in "This Workbook" rather than "Module 1" it will do whatever you want with the workbook rather than regular subs/macros.
    here is a...
  4. Re: Someone else is using the file. Please try again later.

    yes but your sub still opens a workbook.
    my sub would go in the
    A&S CFC Funding Hierarchy.xlsm

    so when you open the workbook (by macro or otherwise) its opening a copy. this would go for...
  5. Re: Someone else is using the file. Please try again later.

    well it would make it so if anyone opened it they are opening a "copy" of it. This is NOT read only so you can still interact with the data etc
    the only time you would have an issue is if two people...
  6. Re: Someone else is using the file. Please try again later.

    Offthelip posted generally what i was getting at
    here is my own version of the solution
    after creating a temporary file folder, copy/paste this into the "This Workbook" code of the "master file"...
  7. Re: Someone else is using the file. Please try again later.

    i think in this instance it would be best to open a copy of the workbook if you have multiple users using the same files.
    I.E make a macro/button to open copies of files, and if someone is making...
  8. Replies
    9
    Views
    111

    Re: Excel Formula to give unique countif

    did you try the code i provided? it should do this without whatever you added
    i'll attach an example:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  9. Re: Delete rows if cell value is not contained on a list

    This should achieve what you want if you create a sheet named "Locations" that has all of the locations in column A with no blanks
    As well just run this on the active sheet where you are trying to...
  10. Re: Delete rows if cell value is not contained on a list

    or could you put this list of locations in an excel sheet attached to the workbook of your report? or perhaps in a separate workbook that will never ever be moved or deleted??
    if so tell me which...
  11. Replies
    9
    Views
    111

    Re: Excel Formula to give unique countif

    oh nevermind. i see you mean that there is cell values that = "No Change" that you would like excluded. so maybe this? hard to tell without an example
    ctrl + shift + enter must be used

    ...
  12. Replies
    9
    Views
    111

    Re: Excel Formula to give unique countif

    does No Change have blanks? (assuming that is a named range, if not please explain what no change is)
    or just the BN3:BN277 range?
  13. Replies
    4
    Views
    89

    Re: Extract a number from a long Cell

    in order for there to be a clean cut way to do this you need to provide some sort of pattern that your data has
    i.e

    if this number always appears after the second set of semicolons, etc
  14. Replies
    11
    Views
    215

    Re: Non Case Sensitive Dictionary

    thank you for the info
    and thank you Rory for the answer
    works a charm
  15. Replies
    2
    Views
    70

    Re: XLSB Corrupted - Can't Open VBA

    safe mode worked just fine :)
    all is good, crisis averted
  16. Replies
    2
    Views
    70

    Re: XLSB Corrupted - Can't Open VBA

    removed the file from the folder XLSB is stored in and all my other workbooks work fine now.
    i'll take this time to backup everything that isn't XLSB, but is there a way for me to view the module...
  17. Replies
    2
    Views
    70

    XLSB Corrupted - Can't Open VBA

    I've gone and donked up my XLSB file somehow.
    i can access the workbook itself but i can not save it, nor can i access the VBA editor to fix whatever vba code is causing this in the first place....
  18. Replies
    11
    Views
    215

    Re: Non Case Sensitive Dictionary

    gotcha. well my XLSB seems to have corrupted so i'll get back to you after i put out this fire
  19. Replies
    11
    Views
    215

    Re: Non Case Sensitive Dictionary

    or does this declaration need to be made before the entries are added to the dictionary?
  20. Replies
    11
    Views
    215

    Re: Non Case Sensitive Dictionary

    i must be doing this incorrectly ?



    dicFINISH.comparemode = TextCompare
    ary2(i, 4) = dicFINISH.Item(ary2(i, 4))
  21. Replies
    11
    Views
    215

    Re: Non Case Sensitive Dictionary

    i don't know that this works with a dictionary object
    i get "424 - object required" when i try to change the dictionary item to lowercase
    when all else fails i can change all of the dictionary...
  22. Replies
    11
    Views
    215

    Non Case Sensitive Dictionary

    So i have a dictionary of colors
    some vendors like to write in all caps, some like to write in proper, some like to write in lowercase, some have their own thing goin on?
    anyways my statement here...
  23. Replies
    3
    Views
    73

    Re: where is properties window vba?

    https://stackoverflow.com/questions/26810053/how-to-restore-vba-editor-to-its-initial-settings
  24. Replies
    1
    Views
    38

    Re: protect conditional formatting

    i believe you're looking for this
    https://www.extendoffice.com/documents/excel/3842-excel-restrict-paste-values-only.html
  25. Replies
    3
    Views
    73

    Re: where is properties window vba?

    when in the visual basic screen click view > properties window
    to get it to expand to its locked position just double click the top of the window (works for me on excel 2016)
    if it still isnt...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4