Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.78 seconds.

  1. Replies
    10
    Views
    3,516

    Re: VBA to delete row based on cell value.

    1. Is your data sorted by column F in any way? If so, please give some details about the sort.
    2. How many rows of data do you have (approximately)?
  2. Re: VBA User Selected Range Error on Cancel

    I presume that in your declarations you meant ..

    Dim rng As Range
    .. though that will not solve the Cancel problem.
    (You have also declared some variables that are not used in the function)
    ...
  3. Re: VBA - Format Rows containing word 'Total'

    The reason that you cannot see which data should be sorted is because you didn't place the code where I suggested ..


    If placed there it will still be acting on the selection you made with this...
  4. Replies
    3
    Views
    94

    Re: Numbering new products in sequence

    Cheers. Lucky guess to some extent! Thanks for the follow-up. :)
  5. Re: VBA Code - Sort by Custom List Reference

    Duplicate to https://www.mrexcel.com/forum/excel-questions/1107148-vba-format-rows-containing-word-total-post5359592.html#post5359592

    Please do not post the same question multiple times. Questions...
  6. Re: VBA - Format Rows containing word 'Total'

    I can now see from your other thread (that I have closed) that my assumption was incorrect.

    You should be able to use your custom sort order without having to actually create a new custom list (&...
  7. Re: VBA Changing interior color based on value of another cell in same row

    Welcome to the MrExcel board!

    Do you really need VBA? Could you just use Conditional formatting like this?

    <b>CF Date Blank Email</b><br /><br /><table border="1" cellspacing="0"...
  8. Replies
    3
    Views
    94

    Re: Numbering new products in sequence

    Is this, copied down, what you mean?

    If not, can you give us a bit more sample data, the expected results and any further clarification?

    <b>Pattern numbers</b><br /><br /><table border="1"...
  9. Replies
    33
    Views
    590

    Re: Deleting Lines with a Macro Command

    Thanks, that does add some clarity though on closer inspection there still is some confusion for me about what is in the various columns. For example, previously column AI contained nicknames and now...
  10. Re: Match Date to Nearest Month + Match with text field

    You're welcome. Hope you are now fully recovered. :)
  11. Re: VBA - Format Rows containing word 'Total'

    I'm not sure this is what you mean but try adding this code immediately above the following line in your code
    Selection.Subtotal GroupBy ....

    I have assumed that the Account numbers in K21:K35...
  12. Re: Group sum in each row according to some condition set in columns

    This seems to produce the results for the samples given, but I'm not particularly confident that I have understood well enough that it will work for all data circumstances. If not please post another...
  13. Re: VBA - Format Rows containing word 'Total'

    You are welcome. Thanks for the follow-up. :)
  14. Replies
    33
    Views
    590

    Re: Deleting Lines with a Macro Command

    There is quite a bit of 'extra' here and I am about to be away for some days and will probably have little or no access to the forum. Still, some things need clarification so that if not resolved by...
  15. Re: In need a VBA script to create sheets from 3 different template sheets and more...

    You're welcome, and thanks for your kind words. :)
  16. Replies
    13
    Views
    434

    Re: SUM the Previous n Cell Values

    Thanks for letting us know.
  17. Re: Sum of multple values, dependant on specifc date (within broader dates)

    Your thread title says you want to sum multiple values, but your first post says you want to count something.
    Are you summing (if so what as I am sure your aren't summing dates) or are you counting?...
  18. Re: Need a formula that only show the set cost figure once for each unique User Id

    Cheers. Thanks for the follow-up. :)
  19. Replies
    91
    Views
    58,845

    Re: Counting Consecutive Cells with value

    This is an Excel forum & I only answer questions on that topic so I am unable to help in relation to Google Sheets. Perhaps somebody else might take up that issue for you.
  20. Replies
    91
    Views
    58,845

    Re: Counting Consecutive Cells with value

    Welcome to the MrExcel board!

    Her are 2 options that I think do what you want. The formulas can be placed wherever you want. In my example, they are each copied down.

    <b>Count Last Seq</b><br...
  21. Replies
    7
    Views
    234

    Re: reversing the order of 2 columns

    If you are interested, here is a vba way to reverse a table (but keep the headings) without looping through the rows and columns.



    Sub Reverse_Table()
    Dim rws As Long, cols As Long
    Dim...
  22. Thread: VBA Formula

    by Peter_SSs
    Replies
    31
    Views
    676

    Re: VBA Formula

    Not with my code ....

    Before:

    <b>Yes</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; ...
  23. Thread: VBA Formula

    by Peter_SSs
    Replies
    31
    Views
    676

    Re: VBA Formula

    What does that mean?

    What are the expected results for your last sample data?
  24. Replies
    11
    Views
    198

    Re: Autofill dates for specified year

    :laugh: That could be it. We can't help if we live "at the bottom of the world".

    Regards
    Peter
  25. Replies
    11
    Views
    198

    Re: Autofill dates for specified year

    I'm not so sure...
    That does some really strange things for me.
    I started out with the whole column formatted as General & my date system is d/m/y
    When I enter 1/1/2019 in A1 it shows up as...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4