Search:

Type: Posts; User: Michael M; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.36 seconds.

  1. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    Is this code slow ???
    I ran the file through my anti virus then opened it.
    After looking at the code on a working file, I'd suggest simply deleting the duplicates on the error sheet.
    The code is...
  2. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    One thing we don't do is open zipped files ......:diablo:...!!
  3. Thread: IF Formula

    by Michael M
    Replies
    4
    Views
    55

    Re: IF Formula

    Glad we could help...thx for the feedback..:beerchug:
  4. Thread: IF Formula

    by Michael M
    Replies
    4
    Views
    55

    Re: IF Formula

    How about...


    =VLOOKUP(H8,Budget!L5:M25,2,0)*I8
  5. Replies
    1
    Views
    52

    Re: Electricity usage

    Have you considered creating a Pivot table and associated chart ?
  6. Replies
    15
    Views
    405

    Re: Pasting down empty filtered Cells?

    Use...


    Sub MM1()
    Dim r As Long
    For r = 1 To Cells(Rows.Count, "V").End(xlUp).Row
    If Range("V" & r).Value = "REFILL TOO SOON:DISPENSED TOO SOON" And Range("A" & r).Value = "" Or _
    ...
  7. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    Sending it by PM means only one person gets to help with your problem !
    and any solution arrived at will be posted back to the board anyway.
  8. Replies
    6
    Views
    171

    Re: VBA-macro require a for next loop

    This for the total code, but is UNTESTED


    Sub Coe_fficient_trend_line2()
    Dim c As Long, r As Long
    c = 2
    For r = 5 To 10
    Range("P" & r).FormulaR1C1 = "=TRUNC(TREND(R3C" & c & ":R20C" & c &...
  9. Replies
    6
    Views
    171

    Re: VBA-macro require a for next loop

    So, something like this....I've done the first sectio, you can do the rest, hopefully


    Sub Coe_fficient_trend_line2()
    Dim c As Long, r As Long
    c = 2
    For r = 5 To 10
    Range("P" &...
  10. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    Post the link to the dropbox file...I think you have to click on share !
  11. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    Sorry that isn't allowed !
    You can't find a link to Dropbox ??

    https://www.dropbox.com/h
  12. Replies
    5
    Views
    91

    Re: Finding Errors using the .Find in VBA

    Maybe this....highlights the error cells in red


    Sub MM1()
    ActiveSheet.Range("N:N").SpecialCells(-4123, 16).Interior.ColorIndex = 3
    End Sub
  13. Thread: Cell Value

    by Michael M
    Replies
    2
    Views
    63

    Re: Cell Value

    I might be missing something here, but......

    Cells(20,5).select
    or

    Cells(20,5).copy

    OR
  14. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    yes it is allowed !
    Normally we would request that you use one of the links provided here...
    https://www.mrexcel.com/forum/about-board/508133-attachments.html

    but I'm guessing with 110 Tabs, it...
  15. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    Any chance of uploading the sheet to dropbox ??
  16. Replies
    10
    Views
    135

    Re: Convert macro

    I don't believe so !
  17. Replies
    10
    Views
    135

    Re: Convert macro

    Holding down the CTRL key and selcting the cells to deselect will work.....but there must always be at least 1 active cell !
  18. Replies
    10
    Views
    135

    Re: Convert macro

    In that case simply add...


    Sub MM1()
    application.screenupdating=false
    Sheets("Sheet1").Activate
    With ActiveSheet.Cells
    .Clear
    .Columns("A:A").ColumnWidth = 36
    ...
  19. Replies
    10
    Views
    135

    Re: Convert macro

    I don't believe so, but what is the problem with using activewindow ??

    Sub MM1()
    Sheets("Sheet1").Activate
    With ActiveSheet.Cells
    .Clear
    .Columns("A:A").ColumnWidth = 36
    ...
  20. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    Is it possible that there is more than one error on a given row....so it copies the row for each error ??
  21. Replies
    17
    Views
    297

    Re: VBA Loop Gives Double Lines of Errors

    So why are you repeating 8,9,10,11 and 12 ??


    If J = 1 Or J = 2 Or J = 6 Or J = 7 _
    Or J = 8 Or J = 9 Or J = 10 Or J = 11 Or J = 12 _
    Or J = 9 Or J = 10 Or J = 11 Or J = 12 Or J = 14 _
  22. Replies
    2
    Views
    74

    Re: VB running with macros disabled

    Seems a bit odd and highly unlikely, but have you tried opening the workbook manually, so as not to trigger the macro

    To run the workbook without triggering the open macro
    Open Excel>>File menu>>...
  23. Replies
    5
    Views
    124

    Re: Excel crashing

    What do you mean by permanently deleted...do they still have data in them ?
    OR
    Do you mean Unseen ?
    If the Latter, select the row after the last row of data>>Press CTRL + Down Arrow>>Rclick>> Hide...
  24. Replies
    5
    Views
    124

    Re: Excel crashing

    When checking the code...makes sure there aren't any Sheet events or calculate events that are firing over and over again.
    I'd also consider having a look at each sheet to see where CTRL + End takes...
  25. Replies
    13
    Views
    354

    Re: Not running as hoped

    If you step through LoadValues_NIST manually and hover over Typer, at no point does it hold a value !
    But why are you trying to create Typer using a function ?
    Could it not simply be created within...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4