Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.48 seconds.

  1. Replies
    10
    Views
    112

    Re: I need with my friend

    Try

    A2=Today()
    E2=DATEDIF(B2,A2,"y")+D2
  2. Replies
    1
    Views
    51

    Re: VBA code to unhide rows with password

    Without further information, try


    Sub MM1()
    With ActiveSheet
    Unprotect Password:="YOURPASSWORD"
    .Cells.EntireRow.Hidden = False
    Protect Password:="YOURPASSWORD"
    End With
    End Sub
  3. Replies
    3
    Views
    63

    Re: Merge/Combine Rows Help

    Do the duplicates always have a zero value in cols "F" & "G" ??
  4. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    Another minor change to the pagebreak section.....but I don't think it will change anything, just cleaner


    ActiveSheet.ResetAllPageBreaks
    With ActiveWindow.SelectedSheets.HPageBreaks
    ...
  5. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    DId you try it on another PC ?
    With what your code does, I wouldn't think it's a PC or memory issue !!
  6. Re: My one week effort code, can you check it up ?

    Try to not use Activate or Select
    for instance, this


    Range("C7").Activate
    ActiveCell.FormulaR1C1 = "=MID(RC[23],33,4)"

    can be
  7. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    You could put dummy data in it ??
  8. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    Does it do the same on another PC ??
    Can you upload the workbook to dropbox and post the link back here ?
  9. Replies
    11
    Views
    225

    Re: facing error while copy

    In that case I'm guessing it's a 3rd party app that is causing the problem.
    Try closing ALL other apps then try the copy and paste.
    If it works, reopen the apps 1 at a time and do a copy and paste...
  10. Replies
    2
    Views
    89

    Re: Excel features no longer working

    There isn't a sheet macro as well is there ??
    AND
    The other users don't have it open do they....or left it open ?
  11. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    So when this is run on the sheets in question, are there other codes / formulas / sheets that may be affected by the results ?
    The codes themselves seem pretty straightforward, and should run almost...
  12. Re: Need text box to be invisible when printing

    Ok, maybe something like this then...in the "ThisWorkbook"


    Sub Workbook_BeforePrint(Cancel As Boolean)
    If TextBox1 = "Please type notes here" Then
    TextBox1.visible=false
    End Sub
  13. Re: Need text box to be invisible when printing

    Copy the lines I provided in post #4 , then insert them in the code that is doing the printing just before the code prints.
    I'm assuming you are using code to do the printouts ??
  14. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    This would also be quicker hiding rows


    Sub MM()
    With Range("K4").CurrentRegion
    .AutoFilter Field:=1, Criteria1:="<>Yes", Operator:=xlAnd, Criteria2:="<>"
    End With
    End Sub
  15. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    Backwards running for the row hiding, means it is only hiding the rows from the bottom, not ALL of the rows each time

    This should be much faster

    Sub Calculate_HideShow_Condition1()...
  16. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    And this one


    Sub Calculate_HideShow_Condition()
    application.screenupdating=False
    With Range("K4:K753")
    .Formula = "simple formula here to return a Yes or No"
    .Value = .Value
    End...
  17. Replies
    15
    Views
    217

    Re: Loop Macro gets progressively slower

    Try changing this

    Sub Hide_Rows()
    Dim i As long
    application.screenupdating=False
    For i = 753 to 4 step -1
    If Range("K" & i).Value= "Yes" then Rows(i).EntireRow.Hidden...
  18. Re: Need row colour to be purple if a value is in a cell for each row

    Do you want to upload the latest version anyway ??
  19. Re: Need row colour to be purple if a value is in a cell for each row

    Dave
    Which version of the quoting workbook is this in ??
  20. Replies
    11
    Views
    225

    Re: facing error while copy

    Have you tried to do the copy and paste with a frsh file.....it sounds like the current file may be corrupted !
  21. Replies
    11
    Views
    225

    Re: facing error while copy

    How big is the picture....in Mb
  22. Replies
    11
    Views
    225

    Re: facing error while copy

    A couple of the tips here might help

    https://answers.microsoft.com/en-us/msoffice/forum/all/error-the-picture-is-too-large-and-will-be/fc8f6431-13c8-47f2-a4ee-2e8c04e50227
  23. Replies
    5
    Views
    282

    Re: vba regulate row height

    Maybe this


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("C:C, F:F, G:G")) Is Nothing Then
    ActiveSheet.Unprotect "987654"
    ...
  24. Replies
    5
    Views
    282

    Re: vba regulate row height

    You can't adjust height of individual cells !
    When a cell height is adjusted the whole row is affected.
  25. Replies
    7
    Views
    515

    Re: Nested IF statement with FIND

    the largest number of characters allowed in a cell is 32767 or 2^15-1
    Having a lookup value of 2^15 therefore guarantees that that value will be larger than anything that SEARCH returns
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4