Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.89 seconds; generated 53 minute(s) ago.

  1. Re: VBA - Format Rows containing word 'Total'

    You are welcome. Thanks for the follow-up. :)
  2. Replies
    32
    Views
    543

    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...
  3. 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. :)
  4. Replies
    13
    Views
    424

    Re: SUM the Previous n Cell Values

    Thanks for letting us know.
  5. 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?...
  6. Re: Need a formula that only show the set cost figure once for each unique User Id

    Cheers. Thanks for the follow-up. :)
  7. Replies
    91
    Views
    58,748

    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.
  8. Replies
    91
    Views
    58,748

    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...
  9. Replies
    7
    Views
    219

    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...
  10. Thread: VBA Formula

    by Peter_SSs
    Replies
    31
    Views
    667

    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; ...
  11. Thread: VBA Formula

    by Peter_SSs
    Replies
    31
    Views
    667

    Re: VBA Formula

    What does that mean?

    What are the expected results for your last sample data?
  12. Replies
    11
    Views
    192

    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
  13. Replies
    11
    Views
    192

    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...
  14. Replies
    11
    Views
    192

    Re: Autofill dates for specified year

    It also assumes that the column is already formatted as Date?
    The Fill Series does not require that assumption.
  15. Replies
    29
    Views
    489

    Re: Reverse Hex Byte Pairs

    You're very welcome. Thanks for the follow-up. :)
  16. Replies
    7
    Views
    219

    Re: reversing the order of 2 columns

    You're welcome.

    .. and of course if the data started out in a jumbled order then sorting wouldn't reverse the table anyway. :)
  17. Re: Keeping key words in row data and delete the rest of the rows Macro updating Please

    No problem, glad to help. :)
  18. Replies
    11
    Views
    192

    Re: Autofill dates for specified year

    It just uses one of Excel's built-in features.
    DataSeries We want some sort of series (pattern)
    Rowcol:=xlColumns Go down columns not across rows.
    Type:=xlChronological We want some sort of date...
  19. Replies
    10
    Views
    152

    Re: vba If condition help..

    You're welcome.

    The option using Instr that I gave in post 2 was not quite correct. I have edited that code so if you are testing, be sure to re-visit post 2 to get the correct code.
  20. Replies
    32
    Views
    543

    Re: Deleting Lines with a Macro Command

    Cheers. :)
  21. Replies
    11
    Views
    192

    Re: Autofill dates for specified year

    If you have the first date in cell A1, then try



    Sub FillDates()
    Range("A1").DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:=xlDay, Step:=1,...
  22. Replies
    32
    Views
    543

    Re: Deleting Lines with a Macro Command

    Then replace that first block of blue code in post 23 with this


    With Range("AK2", Range("AK" & Rows.Count).End(xlUp))
    .Replace What:=")", Replacement:="", LookAt:=xlPart
    .TextToColumns...
  23. Re: Keeping key words in row data and delete the rest of the rows Macro updating Please

    My mistake, I mis-read your request and thought the rows had to start with those texts ( & I hadn't seen post 4 when I drafted my code).
    It is a simple fix, just add this red asterisk

    .AutoFilter...
  24. Replies
    32
    Views
    543

    Re: Deleting Lines with a Macro Command

    Yes, sorry, as I said my suggestion was untested & I forgot about Replace changing the format even though I had set it to text with the "@". :oops:

    After the various rows have been deleted, are...
  25. Replies
    10
    Views
    152

    Re: vba If condition help..

    :huh: Really?? I think you should check again.

    Here's my test of your code line

    Sub Test()
    Dim i As Long

    For i = 1 To 3
    If Sheet1.Cells(i, 1).Value = Green Or Red Or Blue Then
    ...
Results 1 to 25 of 145
Page 1 of 6 1 2 3 4