Search:

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

Search: Search took 0.00 seconds.

  1. Thread: Word Scramble

    by jasgot
    Replies
    9
    Views
    17,916

    MRAND() gives me a #NUM! error This is my...

    MRAND() gives me a #NUM! error

    This is my cell:
    =MRAND(14,1)

    the result is #NUM!

    There must be something wrong...
  2. Thread: Word Scramble

    by jasgot
    Replies
    9
    Views
    17,916

    Wow! Who would of thought Excel counldn't do this...

    Wow! Who would of thought Excel counldn't do this on it's own.

    Where do I get MoreFunc, and, If I use your equation in b2,c2,d2 ...., which all appear to be the same, they all generate a the first...
  3. Thread: Word Scramble

    by jasgot
    Replies
    9
    Views
    17,916

    I want to make a word scramble for my Nephew. ...

    I want to make a word scramble for my Nephew.

    Lacking a Scramble() function :smile: I looked at Rand() and made no progress.

    I would like to take the word in column A and have it scrambled in...
  4. Replies
    1
    Views
    447

    I use this code, (thanks to this board :smile:)...

    I use this code, (thanks to this board :smile:) to name and save my file based on user input. How can I yank out any commas that get put into the VB_Trigger, which will become the filename?
    ...
  5. Replies
    7
    Views
    15,915

    Thanks! It's working. I'll play with the...

    Thanks! It's working.

    I'll play with the parameters and learn something new tonight!
  6. Replies
    7
    Views
    15,915

    I tried it, got a 'run time error 424' Object...

    I tried it, got a 'run time error 424'
    Object required.

    I have no idea what that means!

    thanks for your help my hands will be happy if this works!

    Jason
  7. Replies
    7
    Views
    15,915

    If I place a check box in B2 and link it to A2,...

    If I place a check box in B2 and link it to A2, A2 appropriately respoinds with true or false based on the check box.

    If I copy B2 to B3, the link stayed at A2, it does not adjust to A3 like every...
  8. Replies
    1
    Views
    545

    This works great when I click in the cell and...

    This works great when I click in the cell and change the value:

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If Target.Address = Range("VB_Trigger").Address Then


    How can I...
  9. Replies
    6
    Views
    3,242

    That didn't work, however this did. But it scares...

    That didn't work, however this did. But it scares me to use it. I never like deleting files.....

    If Application.UserName = "Jason Gottschalk" Then
    OriginalSheetPath = "P:SYO Sales...
  10. Replies
    6
    Views
    3,242

    I unprotect the workbook because I have several...

    I unprotect the workbook because I have several locked cells and hidden formulas. One of the cells that this macro changes is a locked cell. There is no password for the protection.
  11. Replies
    6
    Views
    3,242

    I don't think so, but if I did, wouldn't I also...

    I don't think so, but if I did, wouldn't I also have to do it when I save manually?
  12. Replies
    6
    Views
    3,242

    When I use the file menu to SAVE AS, it saves...

    When I use the file menu to SAVE AS, it saves fine, this macro, however, fails with this message:
    "Run time Error 1004
    Operation Failed. Blah...BlahPrices.xls is write reserved."

    Here is the...
  13. Replies
    1
    Views
    5,428

    Worksheet_Change is a private sub, when the...

    Worksheet_Change is a private sub, when the trigger is tripped, it runs.

    I need to temporarily turn it off while I run another macro. How do I do this?

    I've tried...
  14. Replies
    7
    Views
    865

    Thanks! That is very elegant! And it works...

    Thanks!
    That is very elegant!

    And it works :smile:
  15. Replies
    7
    Views
    865

    Back to Top Thanks for the control p fix, I...

    Back to Top

    Thanks for the control p fix, I still have the problem turning the print menu options back on.
  16. Replies
    7
    Views
    865

    btt

    btt
  17. Replies
    7
    Views
    865

    I have a macro that prints after doing some work...

    I have a macro that prints after doing some work for me.

    I would like to disable the print options from the menu and tool bars so the user must click my button in the sheet.

    I've tried these...
  18. Replies
    3
    Views
    513

    This doesn't work, how do I write it correctly? ...

    This doesn't work, how do I write it correctly?

    If Range("b7").Value <> "Telephone Support" Or "Warranty Parts" Then


    Thanks....
    Jason
  19. This updating snippet dd not work, I still get an...

    This updating snippet dd not work, I still get an incredible amount of blinking.

    Also, I am still looking to find out how to apply the above macro to all the rows in my sheet.
  20. I have this little macro that fills in a cell in...

    I have this little macro that fills in a cell in Column D based on what it sees in Column B. It works great for row 7, How can I make it apply to Row 7 through 29?

    Also, this macro really blinks...
  21. Thread: Input from user

    by jasgot
    Replies
    3
    Views
    725

    This is nice, how can I drop it right into a cell...

    This is nice, how can I drop it right into a cell when the sheet opens.
  22. Thread: Input from user

    by jasgot
    Replies
    3
    Views
    725

    I've searched and searched to no avail :sad: I...

    I've searched and searched to no avail :sad:

    I have this sheet that many people use. I currently have an in cell drop down with a list of their names. I want them to select their own name so when...
Results 1 to 22 of 22