Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    66

    Re: Print Every 2 Pages to a New PDF

    Perfect! Thanks a lot for making that macro and sharing it with me. You are the man!

    I appreciate your help
  2. Replies
    3
    Views
    66

    Print Every 2 Pages to a New PDF

    I have a few workbooks with almost 50 pages each, and I want to print every 2 pages to a PDF, so basically the end goal would be 25 pdfs made up of 2 worksheets each

    For Example:
    PDF1 Sheet1 and...
  3. Re: Adjust Formulas for multiple ranges on multiple pages

    Thank you sir
  4. Adjust Formulas for multiple ranges on multiple pages

    I need to change the formulas on several pages for several ranges, by adding an if statement that says if the result is greater than 100% then show 100% or else show the normal result of the formula....
  5. Re: Hiding rows and columns based on cell value

    I put a code that hides cells that match what is in the drop down and I put I code that hides everything that doesn’t match. Anyways, that was your request, so enjoy. And good luck.
  6. Re: VBA Macro has begun hiding rows instead of copying down.

    Well good work, it's pretty cool. and no problem happy to help you.

    I did have one idea that can speed it up for you. You could have a master button, that runs the code to grab the the data and...
  7. Replies
    9
    Views
    225

    Re: Bank Account Format - Data Validation

    Use Kweavers formula

    To restrict the value, you can use data validation -> Text Length -> Between 15 and 16
  8. Re: Excel 2016 will no record macros to change text color

    Are you using conditional Formatting? I've heard of the macros not recording when using "Manage Rules", but working when clicking "New Rule"
  9. Re: Need some insight: Previous code not working

    Not sure I can be much help here, but isn't there an extra bracket?




    .Sort.SortFields.Add Key:=Range("Summary[[#Header],Generate Scorecard]]"), SortOn:=xlSortOnValues, Order:=xlDescending,...
  10. re: Hiding rows and columns based on cell value

    Private Sub Worksheet_Change(ByVal Target As Range)


    If Not Intersect(Target, Range("A1")) Is Nothing Then

    Dim arr(2 To 17, 2 To 11)
    Dim i As Long, x As Long
    ...
  11. re: Hiding rows and columns based on cell value

    Dim arr(5 To 20, 1 To 7)

    You can amend the above portion of the code to have it look at whatever cells you want.
    5 to 20 means Rows 5-20 and then 1-7 means columns 1-7 (columns A to G)

    For B-J...
  12. Re: VBA Macro has begun hiding rows instead of copying down.

    The macro can't run correctly with the filter on
    you can add this in the beggining of your code after the sub name and that will always turn the filter off first. Might want to put that on all your...
  13. Re: VBA Macro has begun hiding rows instead of copying down.

    Okay steady, the rows aren't hidden. The data is filtered. In column F there is a filter that has "all ords" removed. Just remove the filter.
    The reason it keeps hiding the rows, is because the...
  14. Re: VBA Macro has begun hiding rows instead of copying down.

    it's fine i'm stupid so i just realized it was a command button. I ran the macro and it worked, then i closed the workbook and ran it again and it worked perfectly for me. I'm not sure what your...
  15. Re: VBA Macro has begun hiding rows instead of copying down.

    the code you sent above is not a worksheet event, so it should be in a normal module, not inside the worksheet code. A worksheet event is posted into the worksheet itself, and it runs based on an...
  16. Re: VBA Macro has begun hiding rows instead of copying down.

    can you right click on your worksheet tab where it shows the name, and click view code, and check if there is any code in it? (do for both worksheets)
  17. Replies
    24
    Views
    253

    Re: A shorter alternative to IF formula

    No problem, happy to help you. Thanks for the feedback
  18. Replies
    24
    Views
    253

    Re: A shorter alternative to IF formula

    did you try this
    =SUMPRODUCT((A2:C2>0)*(A1:C1>0))

    I noticed in the example c2 is blank, but =isblank(c2) is FALSE does that mean you filled this one with a formula?

    see this
    Compared A3 with...
  19. Replies
    24
    Views
    253

    Re: A shorter alternative to IF formula

    Do you mind if I ask why you want to shorten it?
  20. Re: Copy destination:= is extremely slow with small range???

    I have excel 2019 and it took less than a second for me
    Download the test link you sent and try it in a new workbook
  21. re: Hiding rows and columns based on cell value

    Yes quite odd.
    I'm also guessing he would want to keep cells with "a" hidden after he changes A1 from "a" to "b" due to the "All" selection to clear all the hidden rows. But not really sure without...
  22. re: Hiding rows and columns based on cell value

    rows and columns a5:j20?

    which rows and columns do you want to hide
  23. Replies
    10
    Views
    156

    Re: Need help with countifs formula

    double click in the formula highlight this and press f9
    (IFERROR(FIND(K$1,$B$2:$B$37),0)=1)
    Check the result to see if it's an error, it should be a bunch of trues and falses(ctrl z to put the...
  24. Replies
    10
    Views
    156

    Re: Need help with countifs formula

    ps. I was guessing the number on the far left was supposed to be the row number for you. so I adjusted the top formula to reflect that
  25. Replies
    10
    Views
    156

    Re: Need help with countifs formula

    yes, try this

    =SUMPRODUCT((IFERROR(FIND(AK$3,$AC$4:$AC$39),0)=1)*($AF$4:$AF439=$AJ4))
    double click in the formula once its in cell J2 and use ctrl + Shift + enter

    <b>Excel 2010</b><table...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4