Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    4
    Views
    75

    Re: merge duplicate rows

    Updated code:



    Sub merge_duplicate()
    Dim c As Range, r As Range, f As Range, cell As String, c1 As String
    Dim i As Long, rn As Range
    Set rn = Range("A" & Range("A" &...
  2. Re: Importing multiple files into one tab instead of separate tabs

    Please comment.
  3. Replies
    3
    Views
    33

    Re: VBA Fill in multiple PDF Files

    Another option is to reproduce the PDF format on an excel sheet, fill out the sheet and save as pdf and so for each record.
  4. Replies
    3
    Views
    33

    Re: VBA Fill in multiple PDF Files

    Try opening the file, load the data and close the file for each record.
    I also added the DoEventes instruction to execute the command.



    Sub CreatePDFForms()
    Dim PDFTemplateFile, NewPDFName,...
  5. Re: Help with VBA to return values to given cells

    I'm glad to help you. Thanks for the feedback.
  6. Thread: IF formula

    by DanteAmor
    Replies
    5
    Views
    76

    Re: IF formula

    Youre welcome, thanks for the feedback
  7. Re: Help with VBA to return values to given cells

    Try this

    Change "C:C" for the column with the names.
    Put the code in sheet events.



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If...
  8. Replies
    4
    Views
    75

    Re: merge duplicate rows

    Try this



    Sub merge_duplicate()
    Dim c As Range, r As Range, f As Range, cell As String, c1 As String, c2 As String
    Dim i As Long, rn As Range
    Set rn = Range("A" & Range("A" &...
  9. Thread: IF formula

    by DanteAmor
    Replies
    5
    Views
    76

    Re: IF formula

    If the Fluff assessment is correct you can also use the following:

    =IF(OR(L4={"AB/BC","QC"}),K4/1.05,K4/1.13)
  10. Re: Importing multiple files into one tab instead of separate tabs

    I'm sorry, I forgot to delete that line that I used for my tests.

    I'm glad to help you, thanks for the feedback.
  11. Re: Importing multiple files into one tab instead of separate tabs

    Delete this line


    FolderPath = "C:\trabajo\"
  12. Re: "Paste method of Worksheet class failed" but only on alternate executions

    I'm glad to know that you already have a solution.
  13. Re: Importing multiple files into one tab instead of separate tabs

    Try this



    Sub Import()
    Dim FolderPath As String, Filename As String, Sheet As Worksheet, sh As Worksheet
    Dim lr As Long, lc As Long, lr1 As Long
    Application.ScreenUpdating = False
    ...
  14. Re: "Paste method of Worksheet class failed" but only on alternate executions

    Move this line to the end of the code


    Application.CutCopyMode = xlCopy



    Sub CopyRows()
  15. Replies
    5
    Views
    131

    Re: vba filtering with multiple values

    Works for me.
    Do you have numerical values ​​on the sheet?
    Review your data that has only numerical values.
    Check that there are no spaces in the cells.
    Did you modify some of the macro?
  16. Thread: VBA row ?

    by DanteAmor
    Replies
    8
    Views
    199

    Re: VBA row ?

    I'm glad to help you. Thanks for the feedback.
  17. Re: match / algn to columns and add rows where no match

    I'm glad to help you. I appreciate your kind comments.
  18. Re: userform - user must enter name to begin

    I'm glad to help you. Thanks for the feedback.
  19. Re: match / algn to columns and add rows where no match

    Assuming your data on sheet1 is like this:

    Sheet1
    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col...
  20. Re: userform - user must enter name to begin

    If you have a button in the userform to save the data on the sheet, there you can put the following:



    Private Sub CommandButton1_Click()
    If TextBox20 = "" Then
    MsgBox "Enter your name",...
  21. Replies
    7
    Views
    200

    Re: WorksheetFunction

    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 to the file that you can post here. If the workbook...
  22. Re: Index Match formula with multiple criteria

    Try

    <b>Hoja2</b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  23. Thread: VBA row ?

    by DanteAmor
    Replies
    8
    Views
    199

    Re: VBA row ?

    Try this



    Sub macro()
    Dim c As Range, r As Range
    ActiveSheet.Unprotect
    Set r = Range("B8:B66")
    r.Locked = False
    For Each c In r
  24. Replies
    4
    Views
    129

    Re: Email Code to Email Active XLSX sheet

    Glad to help you, thanks for the feedback.
  25. Replies
    4
    Views
    129

    Re: Email Code to Email Active XLSX sheet

    Try this



    Sub CreateEmail()
    Dim olMail As Object, ws As Worksheet, fName As String
    Set olMail = CreateObject("Outlook.Application").createItem(0)
    Set ws = ActiveSheet
    fName =...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4