Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.36 seconds.

  1. Re: VBA Autoprotect sheet and allow filtering

    You set up the filter dropdowns first then change


    For Each ws In ThisWorkbook.Worksheets
    ws.Protect "Password"
    Next ws

    to
  2. Replies
    10
    Views
    63

    Re: VBA filling loop

    =ISBLANK(Y26) returned TRUE and LEN(Y26) returned 0 but ran the code again after re-copying the data from post 4 and it filled Y26.... confused but not going to get to the bottom of it as it now is...
  3. Replies
    5
    Views
    87

    Re: Running a Macro Several Times

    If I am understanding correctly then maybe.....


    Sub transCode()
    Dim i As Long
    Application.ScreenUpdating = False
    For i = 2 To Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Row...
  4. Replies
    10
    Views
    63

    Re: VBA filling loop

    Hi Fluff, the code didn't put an "ON" in Y26 for me.
  5. Replies
    10
    Views
    63

    Re: VBA filling loop

    Just to be clear what would you want the below to look like in terms of the filling. Incuding if any bits aren't possible in your data

    <b></b><table cellpadding="2.5px" rules="all"...
  6. Replies
    10
    Views
    63

    Re: VBA filling loop

    Are you just saying that you want to fill the blank cells in-between and then filter on the "ON" cells? does the "OFF" in Y20 then fill down to the next "ON"?
  7. Replies
    5
    Views
    87

    Re: Running a Macro Several Times

    A bit confused the only formula (therefore the only value that changes) in Sheet1 is B4 (the ACTUAL INTEREST result) but the D column in Sheet2 is headed ANNUAL RATE (which is a fixed value in...
  8. Replies
    2
    Views
    39

    Re: VBA dropdown list

    Change all your ; to , in your string.
  9. Replies
    4
    Views
    566

    Re: =UNIQUE coming to O365?

    Demo table of previous post in link below

    https://www.mrexcel.com/forum/test-here/1112494-demo-question.html#post5357053
  10. Replies
    4
    Views
    566

    Re: =UNIQUE coming to O365?

    If doing a vertical list with data in A2:A12, Formula in B2 and dragged down....
  11. Replies
    5
    Views
    87

    Re: Running a Macro Several Times

    Please post your macro

    What? it will put in exactly the same values from M1 to M6 into all the cells in columns A to F for 1000 (variable) rows?

    variable/row count of based on what? a certain...
  12. Replies
    9
    Views
    22,408

    Re: convert M/D/YYYY to MM/DD/YYYY

    If it has truly worked then they should all be "real" dates now and so you should be able to format the cells as you wish. If you can't then there is still an issue.
  13. Replies
    9
    Views
    22,408

    Re: convert M/D/YYYY to MM/DD/YYYY

    Try the below on a copy of your worksheet.

    Select the column, click "Data" tab - click "Text To Columns" - select "Delimited" and click "Next", make sure "Other" is not checked and click "Next",...
  14. Replies
    2
    Views
    84

    Re: how to become excel 365 insider

    Btw, I think this really should have been posted I the General Excel Discussion & Other Questions forum. ;)
  15. Replies
    2
    Views
    84

    Re: how to become excel 365 insider

    Are you sure it is 365 and not 2019 as I can only see Student as an option on the one-time purchase option which is Office 2019 Home and Student not 365 which is subscription based.
    ...
  16. Re: VBA move print area down 1 row from active cell

    If you are Offsetting by 0 then you might as well just remove it :rofl:
  17. Replies
    6
    Views
    142

    Re: Commenting the below macro

    No but there is no point commenting the scripting dictionary part unless you have a basic understanding how it works. If you tell us exactly what you are trying to amend then maybe someone can at...
  18. Replies
    5
    Views
    67

    Re: ifs() not in office 365

    Are you sure that you don't have it? It is in my 365.

    <b>Excel 2016 (Windows) 64 bit</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255, 255, 255);border: 1px...
  19. Replies
    5
    Views
    150

    Re: Maximum file sizes

    Then run the macro Logit posted on a copy of your workbook as suggested to see if it makes a difference (just change the .Clear to .Delete)
  20. Re: Error if only one row to copy and paste to another sheet VBA

    Does the below do what you want?


    Sheets("Bryan").Range("A2").CurrentRegion.Copy
    Sheets("Q4").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
  21. Thread: if+and

    by MARK858
    Replies
    4
    Views
    119

    Re: if+and

    ...
  22. Replies
    6
    Views
    142

    Re: Commenting the below macro

    That answers the question....

    All of this part of the code is using the scripting dictionary


    Set dic = CreateObject("Scripting.Dictionary")
    Set dicAgnt =...
  23. Replies
    7
    Views
    204

    Re: Scroll to last cell with date

    #sharky12345 , actually are your column widths wide enough to show the full date?
  24. Replies
    7
    Views
    204

    Re: Scroll to last cell with date

    No error when I run it so no unless you are using a Mac.


    M.A.I.T, that isn't what the question says.
  25. Replies
    7
    Views
    204

    Re: Scroll to last cell with date

    Maybe...


    Sub findlastdate()
    Application.Goto Columns(5).Find(CDate(Date), , xlValues, , xlByRows, xlPrevious), True
    End Sub
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4