Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Help with a macro please-runs fine on one pc but not another

    Hi Domenic,

    I just figured it out. IE was running in the background. I put a line of code in the beginning of the macro
    to make sure it is completely closed.

    Thanks for the help!
  2. Help with a macro please-runs fine on one pc but not another

    Hi Everyone,

    I am running a macro that in a nutshell Opens Internet Explorer, does Select All and Copy, and then pastes to
    cell A1 in a worksheet. It works flawlessly on one PC but hangs up on...
  3. Replies
    3
    Views
    144

    Re: Need help with runtime error 6 overflow

    Joe 4,

    That did the trick!

    Thank you!
  4. Replies
    8
    Views
    232

    Re: Need help with a delete macro

    Hi Fluff,

    I was able to get this resolved.

    Thanks for your help!!
  5. Replies
    3
    Views
    144

    Need help with runtime error 6 overflow

    Hi Everyone,

    I am getting a runtime error(runtime error 6 overflow) when selecting ALL cells in a worksheet.
    This sheet has a pop up calendar referencing cell J3.
    Debug shows the error in the...
  6. Replies
    8
    Views
    232

    Re: Need help with a delete macro

    Hi Fluff,
    It works BUT its messing up another macro so I need to change it. Stay tuned.

    Thank you!
  7. Replies
    8
    Views
    232

    Re: Need help with a delete macro

    Fluff,

    I think I got it if this looks correct to you?



    With Range("A2", Range("A" & Rows.Count).End(xlUp))
    .Value = Evaluate(Replace("if(left(@,1)=""0"",@,"""")", "@", .Address))
    ...
  8. Replies
    8
    Views
    232

    Re: Need help with a delete macro

    Hi Fluff,

    They are text.

    Thank you!
  9. Replies
    8
    Views
    232

    Need help with a delete macro

    Hi Everyone,

    I have a worksheet with close to 1000 rows. I want to delete ALL rows where the VALUE in Column A DOES NOT
    BEGIN with ZERO with a macro.

    Any help would be appreciated!

    Thank...
  10. Need help with an excel pop up calendar property

    Hi Everyone,

    Wondering if anyone knows how to change the Excel pop up calendar to show the correct month, day & year?
    The tag at the bottom of the calendar shows Today:5/4/2019 but the calendar...
  11. Replies
    0
    Views
    119

    Macro to import an html file

    Hi Everyone

    I have an HTML file that resides on a local drive(C:\Users\HOME\Dropbox\DAILY_SALES_REPORTS\DAY_END.HTML)
    but opens in a web browser.

    All I need is to copy the entire main body of...
  12. Replies
    2
    Views
    135

    Re: Help with a macro please

    Hi JLGWhiz,

    What I just discovered is the macro is loading what was most recently copied in A1 so I am going down the wrong path. What I need is a macro
    that will open the HTML in Internet...
  13. Replies
    2
    Views
    135

    Help with a macro please

    Hi Everyone,

    The macro below is an HTML copy from a folder(file:///C:/Users/HOME/Dropbox/DAILY_SALES_REPORTS/DAY_END.HTML) and pasted to a worksheet(IMPORT_HTML). Works like a charm until the...
  14. Re: Extracting data from website HTML using VBA

    Hi Domenic,

    I have a very similar situation with the exception of my HTML(file:///C:/Users/HOME/Dropbox/DAILY_SALES_REPORTS/DAY_END.HTML) has anywhere from 28-35 separate tables daily however the...
  15. Replies
    1
    Views
    144

    Importing HTML

    Hi Everyone,

    I am looking for ideas getting an HTML document into Excel. I've tried the standard "Get Data" but I end up with a 4MB file
    and have 30-35 tables daily. If its possible to import the...
  16. Replies
    8
    Views
    244

    Re: Help with a macro please

    THANK YOU Michael and Dante!

    Much appreciated!
  17. Replies
    8
    Views
    244

    Re: Help with a macro please

    Michael,
    I messed up! This works great in my test sheet where the first column is "A" however in the actual sheet the first column is "D".
    I tried changing the macro to the following but that...
  18. Replies
    8
    Views
    244

    Re: Help with a macro please

    Hi there,

    A6 & B6 would go in A7, A8, B7 & B8!

    Thank you!
  19. Replies
    8
    Views
    244

    Help with a macro please

    Hi Everyone,

    I have a workbook with Sheet 1 in it. Each day Sheet 1 is updated with up to 600 rows of data. We have several rows that we need to copy data to for example, where Cells A3, A4, B3 &...
  20. Replies
    3
    Views
    186

    Re: Help with a macro please

    Thank you Mumps! That did the trick!!

    Have a great day!!
  21. Replies
    3
    Views
    186

    Help with a macro please

    Hi Everyone,

    I need to run a macro that would insert the DAY in C2 based on the DATE in B2 so if B2 is 4/10/19, then C2 would be Wednesday.

    Thank You!
  22. Replies
    7
    Views
    109

    Re: Hide rows after last entry macro

    Hi Fluff,

    or white text on a white background.....I'm losing my mind!!

    Thanks again!
  23. Replies
    7
    Views
    109

    Re: Hide rows after last entry macro

    Hi Fluff,

    My bad. I missed "A". Changed to "B" and all is good. Sorry!
    Quick question off topic a bit. I'm running a macro that inserts
    today's Date in B2. In the formula bar I see 4/4/2019 but...
  24. Replies
    7
    Views
    109

    Re: Hide rows after last entry macro

    Hi Fluff,

    That hides all the rows in the sheet! We just want to hide rows after the last entry please.

    Thanks
  25. Replies
    7
    Views
    109

    Hide rows after last entry macro

    Hi Everyone,

    We import approximately 400 rows of data into a spreadsheet. I would like to hide all rows after the last entry with a macro.
    The caveat is that the last populated row is not the...
Results 1 to 25 of 138
Page 1 of 6 1 2 3 4