Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.40 seconds.

  1. Re: CountIF Formula if cell is yellow and has Satisfactory

    Try putting the code below in a regular module, then use the formula below.
    Please note that it will only pick up the standard yellow, if they don't use it then we can change the code so that it is...
  2. Replies
    4
    Views
    39

    Re: VBA PasteAll Question

    What happens if you paste the values and formats separately? i.e.



    Workbooks("CB2.xlsx").Worksheets("Sheet1").Range("A3:E500").Copy
    With...
  3. Replies
    7
    Views
    135

    Re: VLOOKUP help (not SUMIF)

    Why is it a long work around? you have a list of your unique names and just drag (or if the names are in the next column autofill) the formula down. There are only 3 formula there 1 for the people, 1...
  4. Re: CountIF Formula if cell is yellow and has Satisfactory

    How is the cell coloured with a manual fill or conditional formatting?
  5. Re: CountIF Formula if cell is yellow and has Satisfactory

    You can't as a formula can't detect a colour, you either have to test for the condition that the cell is coloured based on or use a VBA function (and even then it depends whether your cell is...
  6. Replies
    7
    Views
    135

    Re: VLOOKUP help (not SUMIF)

    Why not SumIf :confused: and SumIfs if you want a combination of Person/Product?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  7. Replies
    8
    Views
    141

    Re: Trouble Using Formulas in VBA

    As Michael has stated (posted quicker than me)


    Set Off_Since = Range(Off_SinceSC, Off_SinceSC.End(xlUp))


    is creating a multicell range


    but you are using it in Datediff which requires...
  8. Replies
    8
    Views
    141

    Re: Trouble Using Formulas in VBA

    Post the code as you now have it and tell us what line it errors out on for you.
  9. Replies
    8
    Views
    141

    Re: Trouble Using Formulas in VBA

    Did you try the change below?
  10. Replies
    2
    Views
    94

    Re: Forgot Password of excel file

    As per the forum rule below there is nothing we can do to help you get past the password, all I can say is "Google is your friend".
  11. Replies
    12
    Views
    237

    Re: Button to add column to the end of a table

    That is why the code by FormR doesn't work for you try



    Sub ResizeNamedRange2()
    Dim xName As Name
    Set xName = ActiveWorkbook.Names.Item("CompTable")
    With xName
    .RefersTo...
  12. Replies
    12
    Views
    237

    Re: Button to add column to the end of a table

    FormR's code works fine for me. First of all you describe it as a table then you state "the name of the range is “CompTable”".
    So is it an actual table (where you selected the range then clicked...
  13. Replies
    12
    Views
    237

    Re: Button to add column to the end of a table

    Subscript out of range normally means that something is named incorrectly. Double check that your sheet name and table name exactly match including capitalisation and for leading and trailing spaces.
  14. Replies
    3
    Views
    45

    Re: My macro not working

    As Joe4 has pointed out the reason your code isn't working is that Fare needed to be all capitals but also you don't need the End If as you are only doing a single test so it can all go on the one...
  15. Replies
    5
    Views
    28

    Re: Detect Last Filled Row

    Try
  16. Replies
    9
    Views
    81

    Re: VBA Code to Copy All USed Rows

    If you are still having issues try the codes below, the first doesn't include formulas returning "" in the range, the second one does include formulas returning "" in the range.



    Sub...
  17. Replies
    9
    Views
    81

    Re: VBA Code to Copy All USed Rows

    When I get back in I will hopefully post some code that doesn't retain a memory as UsedRange and LastCell does.
  18. Replies
    9
    Views
    81

    Re: VBA Code to Copy All USed Rows

    Despite the various possible issues maybe...

    ActiveSheet.UsedRange.Copy
  19. Re: Code Not sending email when worksheet range is changed

    Try running the macro below and see if it makes a difference.


    Sub xxxx()
    Application.EnableEvents = True
    End Sub

    Also beforehand go Tools - Reset.
  20. Replies
    12
    Views
    125

    Re: Hello board - finding a date in a column

    Bad typing, it should have read...
  21. Replies
    12
    Views
    125

    Re: Hello board - finding a date in a column

    EOMONTH takes account of bank holidays and WORKDAY has another parameter you can add for a range of holiday dates.

    The VBA for the Find is relatively straightforward (when you are on a PC and not...
  22. Replies
    12
    Views
    125

    Re: Hello board - finding a date in a column

    Just going out for a few hours so no time to write any VBA but if you were to do it with formula I think the below works so hopefully you can adapt the principle.

    <b>Sheet3</b><br /><br /><table...
  23. Replies
    12
    Views
    125

    Re: Hello board - finding a date in a column

    MrTreasury, if the last day of the month is a Monday (as it is in September) what do you want returned the Monday or the previous Friday?
  24. Re: Value not equaling what it should -- can't figure out why

    Btw, I think the links Fazza was trying to post are below (somehow there wa a double URL in the links).
    ...
  25. Re: Value not equaling what it should -- can't figure out why

    mcomp72, further to what Fazza has stated you possibly have a floating point precision issue, see the link below (hard to tell without seeing all your calculations).

    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4