Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    1
    Views
    35

    Re: Index match/VBA/Vlookup

    Try this array formula

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  2. Replies
    6
    Views
    53

    Re: VBA runtime 91 error

    Do not use the On Error instruction, that causes any error to jump at the end of the program and you will not know in which line you have the problem.
  3. Replies
    6
    Views
    53

    Re: VBA runtime 91 error

    The error is the delete line.

    findvalue.EntireRow.Delete


    If it does not find the data then the object findvalue is empty.
    You can verify it this way:

    1. Remove the On Error statement. It...
  4. Replies
    6
    Views
    53

    Re: VBA runtime 91 error

    On which line does the code stop?


    In this line a parenthesis is missing



    Addme.Offset(0, 8).Value = UserName()
  5. Re: Unable to set PageBReak property of Range Class?

    You are adding too many page break.

    You are adding a page break for each empty cell in column A.

    Try this



    Sub Macro1()
    Dim myRow, myStop
  6. Re: Unable to set PageBReak property of Range Class?

    Change this line



    ActiveCell.PageBreak = xlPageBreakManual


    For this
  7. Re: VBA Error window has changed - no more Debug button

    Mielk comment the same on this link, but there is no solution.


    answered Jul 15 '16 at 2:20
    https://www.gravatar.com/avatar/e3d1eaeba1b98ecb9d37ccb68c69aec0?s=32&d=identicon&r=PG&f=1

    mielk
  8. Re: Extract unique values from multiple columns in one row

    Try this



    Sub Extract_unique_values()
    Dim r As Range, a() As Variant, i As Long, j As Long, dict As Object
    Set r = Range("AV1:CK" & Range("AV" & Rows.Count).End(xlUp).Row)
    Set dict =...
  9. Replies
    5
    Views
    105

    Re: VBA Copy Cells error 1004

    Glad to help you and thanks for the feedback.
  10. Re: VBA Error window has changed - no more Debug button

    If you don't have a password in the project, then you could copy the data from each sheet to the new book and also copy modules and userform to the new book.

    When a sheet or book is damaged,...
  11. Replies
    2
    Views
    81

    Re: Transpose rows based on specific text

    The following may be an option. Transpose every 13 data.
    The result will be on sheet2

    Change data in red by your information



    Sub Transpose_rows()
    Dim sh1 As Worksheet, i As Long
    Set...
  12. Re: VBA Error window has changed - no more Debug button

    Apparently it's an editor error, check the following:

    https://answers.microsoft.com/en-us/msoffice/forum/all/excel-2016-mac-vba-debug-button-does-nothing/e0c38c46-9d27-4330-86ae-b20606d6bf9f?page=2
  13. Replies
    15
    Views
    330

    Re: WorksheetFunction

    Try to make the adjustments in the other forms, if you have any difficulty I will gladly review it.
  14. Re: VBA Error window has changed - no more Debug button

    If the project is password protected, then the debug button does not appear, since the code is not enabled until the correct password is entered.
  15. Re: VBA Error window has changed - no more Debug button

    I'm sorry, I understood, the debug button was lost :banghead:

    I guess something in your version of excel-vba was updated.
  16. Replies
    15
    Views
    330

    Re: WorksheetFunction

    Try this, for the userform1




    Dim sh1 As Worksheet, sh2 As Worksheet


    Private Sub CommandButton1_Click()
    'EditAdd
  17. Replies
    15
    Views
    330

    Re: WorksheetFunction

    ok, Another question.
    Does the "Asset Number" relate to column A of the "Count" sheet?
  18. Replies
    5
    Views
    105

    Re: VBA Copy Cells error 1004

    You could check if there are visible rows like this:




    Sub test()
    Dim ws1 As Worksheet, Lrow As Long, lr2 As Long
    Set ws1 = ActiveSheet
    ws1.Select
    If ws1.AutoFilterMode Then...
  19. Thread: VBA row ?

    by DanteAmor
    Replies
    12
    Views
    308

    Re: VBA row ?

    Sorry, but I still don't understand what you need.
    We better start from the beginning, forget your code, forget my code and explain what you need using real examples.
  20. Re: VBA Error window has changed - no more Debug button

    The error is because you are doing a division by 0. But that says the message, to review it, you could put your complete code.
  21. Re: Help with VBA to return values to given cells

    I put my comments



    I could gladly modify the code for your needs. But I am not sure what you require.


    I recommend you create a new thread where you explain in detail how your data is, if...
  22. Replies
    5
    Views
    129

    Re: Survey data to capture full month

    I did not understand.
    Did any option work for you?

    You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link...
  23. Replies
    15
    Views
    330

    Re: WorksheetFunction

    Sorry, but I am not understanding.
    You can go more calmly.
    In the userform1 "Stock count" you have 3 labels:
    - Tote
    - Quantity
    - ID
    What will you capture in each field?
    In which sheet are you...
  24. Replies
    4
    Views
    54

    Re: Attachment Download

    Check the following code:

    https://www.mrexcel.com/forum/general-excel-discussion-other-questions/1100494-macro-download-outlook-attachments-not-working.html
  25. Replies
    5
    Views
    129

    Re: Survey data to capture full month

    You just need to check the "Answered" date, so it could be:


    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4