Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    5
    Views
    90

    Re: Email VBA pull email address from cell

    .
    You are welcome. Glad to help.
  2. Replies
    5
    Views
    90

    Re: Email VBA pull email address from cell

    .
    Try :



    Option Explicit


    Sub MailTest()
    ActiveWorkbook.SendMail Sheets("Directions").Range("A10").Value, "Leader Standard Work for previous week " & Date
  3. Replies
    10
    Views
    182

    Re: Userform UPDATE record and date issue

    .
    Here is the update to your UPDATE button :





    Private Sub cmdupdate_Click()
    Dim x As Long
    Dim y As Long
  4. Replies
    10
    Views
    182

    Re: Userform UPDATE record and date issue

    .
    You could add code to your existing macros to force Cols D & F to display the date as Day / Month / Year.

    However, I simply highlighted both columns and used the FORMAT command to accomplish...
  5. Replies
    10
    Views
    182

    Re: Userform UPDATE record and date issue

    This forum doesn't provide a means of uploading files. You can post your code but it is always more efficient to
    provide your sample workbook.

    You can load the workbook to a cloud site like...
  6. Replies
    3
    Views
    93

    Re: Privacy sheet tabs

    .
    Have you made progress ?
  7. Replies
    9
    Views
    173

    Re: Hide Rows Based on Cell Value

    .
    You are welcome.
  8. Thread: Save as pdf

    by Logit
    Replies
    7
    Views
    161

    Re: Save as pdf

    .
    Glad you have a solution and that I could assist.

    Cheers.
  9. Thread: Save as pdf

    by Logit
    Replies
    7
    Views
    161

    Re: Save as pdf

    .
    Here is one method :



    Option Explicit


    Sub SaveOutput()
    Dim folderChoice
  10. Replies
    3
    Views
    93

    Re: Privacy sheet tabs

    .
    You could apply a password that appears when the workbook first opens. The user can't do anything until they enter their own password,
    then only their TAB appears.

    Or ... you could create a...
  11. Replies
    9
    Views
    157

    Re: Cash Counting sheet

    .
    I believe you will find the need to use one sheet per day of operation.
  12. Replies
    9
    Views
    187

    Re: Resume macro to next line when get Prompt

    .
    Based on your comment :




    Hopefully another volunteer can assist.
  13. Replies
    9
    Views
    157

    Re: Cash Counting sheet

    .
    You are welcome.
  14. Replies
    9
    Views
    157

    Re: Cash Counting sheet

    .
    This is a clean cut and straight forward form with all the formulas included :

    https://www.amazon.com/clouddrive/share/HWyCP2XMZrLicC2R37G9TfdqhFOVxGUIsHBMZ5pDSKy
  15. Replies
    9
    Views
    157

    Re: Cash Counting sheet

    .

    https://www.pinterest.com/pin/153052087323376442/


    Plenty of examples here ^^^^^

    Have you ever completed a Cash Register Reconciliation form ? Perhaps worked in a grocery store ?
  16. Replies
    9
    Views
    157

    Re: Cash Counting sheet

    .
    I suspect you not in the States ? Perhaps UK ?

    What denominations are you speaking of ?

    Define : Notes / Floats


    Your description suggests keeping track of the dollar amounts of each...
  17. Replies
    9
    Views
    187

    Re: Resume macro to next line when get Prompt

    .
    You can include the statement :

    On Error Resume Next

    placed at the beginning of your macro.

    That should cause Excel to ignore any errors and simply move on with the code but
    it doesn't...
  18. Replies
    9
    Views
    173

    Re: Hide Rows Based on Cell Value

    .
    I suspect your workbook sheets may have "invisible data" residing in a large segment of rows on your worksheets.
    Sometimes, in my experience, when the workbook encounters several errors or even...
  19. Thread: VBA Help

    by Logit
    Replies
    13
    Views
    209

    Re: VBA Help

    .
    Ok ... better understanding.

    The example provided does place the new tabs after all other tabs already in existence.

    This link will give you example macros for alphabetizing the tabs....
  20. Replies
    9
    Views
    173

    Re: Hide Rows Based on Cell Value

    .
    How long is your macro taking ?

    This macro hid all rows in under 1 sec. I populated 1,000 rows.



    Sub HideRows()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("sheet1")
  21. Thread: VBA Help

    by Logit
    Replies
    13
    Views
    209

    Re: VBA Help

    .
    "But it is not creating the tabs at the end or in Alphabetical order."

    At the end of what ?

    The tabs are created in the order found beginning on Row #2 and moving down. Arranging in...
  22. Thread: VBA Help

    by Logit
    Replies
    13
    Views
    209

    Re: VBA Help

    You can download my example here :

    https://www.amazon.com/clouddrive/share/hv0PnCGyHi444ZLwTNHMwhJfhYkDw24JtWEjYdI6mNc
  23. Thread: VBA Help

    by Logit
    Replies
    13
    Views
    209

    Re: VBA Help

    .
    The only thing I can suggest is to :

    Quit Excel.

    Shut down your computer.

    Turn it back on.

    Try the workbook again.
  24. Thread: VBA Help

    by Logit
    Replies
    13
    Views
    209

    Re: VBA Help

    .
    The edits in the macro function as expected here. Something else going on with your workbook ?

    Is there additional code were aren't aware of ?
  25. Thread: VBA Help

    by Logit
    Replies
    13
    Views
    209

    Re: VBA Help

    Option Explicit


    Sub Kyosti()
    Dim Cl As Range
    Dim Ws As Worksheet
    Dim Ky As Variant


    Set Ws = Sheets("Sheet1")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4