Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Macro to reset column to first item in data validation drop down list

    create account on dropbox.com (or box.com) and share the link in this post.
  2. Re: Macro to reset column to first item in data validation drop down list

    can you upload a sample (desensitized) workbook (use box or dropbox if you need)?
  3. Replies
    10
    Views
    253

    Re: Save PDF to a folder using VBA

    goto the top of the post. click 'Thread Tools', choose Solved. then thank me (under my post name) if your happy with the service
  4. Re: VBA code that stops and alerts user of error

    ok put this statement on line 2 just under your Dim Statement:


    On Error GoTo ErrHandler:

    put this after application.screenupdating = true statement:


    Exit Sub
    ErrHandler:
  5. Re: VBA code that stops and alerts user of error

    looking into it
  6. Replies
    10
    Views
    253

    Re: Save PDF to a folder using VBA

    if this fixed the issue for you, please mark the thread as solved and please thank or like me if i helped you in any way.
  7. Replies
    10
    Views
    253

    Re: Save PDF to a folder using VBA

    still confused. you download a PDF (from SAP) into your temp folder and the PDF is open, correct?
    you want to press a button in excel to copy from c:\temp to c:\YourFolder, yes? (that can be done as...
  8. Replies
    10
    Views
    253

    Re: Save PDF to a folder using VBA

    so you save the file in SAP. then you go to excel. you press a button and file copies to new location. is that correct?
  9. Replies
    10
    Views
    253

    Re: Save PDF to a folder using VBA

    when you say you downloaded a pdf file from sap, where does it go? why do you need excel to save it again. not understanding what you want done.
  10. Replies
    12
    Views
    219

    Re: Excel saving a file witout quotations

    to post your workbook,go to http://www.tinyupload.com/ and upload. then post the URL to this forum
  11. Replies
    7
    Views
    157

    Re: Excel Countifs Formula

    thanks marcelo, didn't know about sumproduct. great information
  12. Replies
    13
    Views
    220

    Re: VBA code to reset dependent dropdown

    so if i understand your code (should work), you would clear the contents of G17 to G19 if the cells in G13 - G15 change, is that correct?
  13. Replies
    7
    Views
    157

    Re: Excel Countifs Formula

    nothing works on a closed workbook, you will have to open it to run your formulas
  14. Replies
    12
    Views
    219

    Re: Excel saving a file witout quotations

    i ran your code and it worked, don't see the quote marks though. maybe post your workbook.
  15. Replies
    13
    Views
    220

    Re: VBA code to reset dependent dropdown

    can you post your code (whatever you have)?
  16. Re: VBA to copy cell value from the last row of the workbook to another workbook

    thanks for the comment and mention. good luck in your endeavors.
  17. Thread: IF statement

    by Danmc
    Replies
    10
    Views
    169

    Re: IF statement

    honestly don't know if you can do this with a formula, might have to ask one of the guru's.
  18. Thread: IF statement

    by Danmc
    Replies
    10
    Views
    169

    Re: IF statement

    try this:



    sub do_time()
    dim x as date
    x = now()
    putrangehere = "=if(f6 = "", "", x)"
  19. Re: Run Time Error '91' : Object Variable or With Block not Set

    thanks fluff, thought it was a range (address).
  20. Re: Run Time Error '91' : Object Variable or With Block not Set

    try this:


    set s3FirstAddress = r3Find.Address
  21. Re: VBA to copy cell value from the last row of the workbook to another workbook

    is Data.xlsx open? if not, it needs to be open for this macro to run properly.
  22. Thread: IF and VLOOKUP

    by Danmc
    Replies
    5
    Views
    182

    Re: Help witth IF and VLOOKUP

    Goto File -> Options -> Advanced -> Under 'display options for this workbook' uncheck "Show a zero in cells that have zero value"

    does that work for you?
  23. Re: VBA to copy cell value from the last row of the workbook to another workbook

    Sub transfer()
    Dim wb As Workbook
    Dim ws As Worksheet
    Dim LastRow As Long
    Set wb = Workbooks("Data.xlsx")
    Set ws = wb.Sheets("Sheet1")
    LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row...
  24. Re: VBA to copy cell value from the last row of the workbook to another workbook

    Sub transfer()
    Dim wb As Workbook
    Dim ws As Worksheet
    Dim LastRow As Long
    Set wb = ThisWorkbook
    Set ws = wb.Sheets("Sheet1")
    LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row...
  25. Re: VBA to copy cell value from the last row of the workbook to another workbook

    so your saying that you need the last cell in column A then?
Results 1 to 25 of 33
Page 1 of 2 1 2