Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.83 seconds.

  1. Re: Adding Hyphen in Between of Strings Using Macros

    On re-reading, I think my _v1 should be this.


    Sub Insert_Dashes_v1()
    Dim RX As Object
    Dim a As Variant
    Dim i As Long

    Set RX = CreateObject("VBScript.RegExp")
    RX.Global = True
  2. Re: Adding Hyphen in Between of Strings Using Macros

    Edit: I think that I have misinterpreted the data, I'll post again soon in case this was incorrect (at least the first option)


    Here are a couple of macros for your consideration.
    Suggest you...
  3. Re: Excel: Macro to highlight Positive and Negative Numbers

    Sorry, I don't think there is any easy way to adapt my code to do that.
  4. Replies
    6
    Views
    67

    Re: populate cells using

    If the tables are formal Excel tables (Insert ribbon tab -> Table -> My table has headers) called Table1 and Table2 then try this formula copied across the top row of Table 2. You may need to then go...
  5. Replies
    3
    Views
    40

    Re: speeding up loop

    This should be even quicker. This one only acts on the active sheet though. I have assumed the sheet has a heading row. If not, please advise.
    If you want it extended to other sheets, is it all...
  6. Replies
    10
    Views
    269

    Re: 0 formula with blank cells

    OK, glad it became clear in the end. :)
  7. Re: Adding Hyphen in Between of Strings Using Macros

    One example is not a lot to go on.

    Are all the values in column A 2 sets of 10 characters with a space between? If not, could we have a few more samples showing the variety of data and the...
  8. Replies
    8
    Views
    127

    Re: Code for character allowance in cell

    OK, good. :biggrin:
  9. Re: VBA: If Range Contains Cell Value Copy than del

    OK, that certainly could cause the same problem as not removing the 'ws'
    Glad it is working now.
  10. Replies
    79
    Views
    6,607

    Re: Extract multiple keywords from text string

    In all the sample data we have had I don't know that we have had any descriptions that contained more than one Item did we?

    In any case is post 49 that you kept referring me to, you specifically...
  11. Re: VBA: If Range Contains Cell Value Copy than del

    I think that you have still not implemented everything that I told you in post 5




    If you then still have problems, please post the actual code that you are using using.
  12. Replies
    3
    Views
    42

    Re: VBA subtotal depending on indent

    Just checking a bit more ..

    Before this process is started, does your column B look like you have shown in post 3 or does it look like my column B below, or something else?

    By "indent" do you...
  13. Re: Splitting out title, first name, middle name, last name

    Cheers. :)

    Just playing with the OP's Text to Columns idea a bit more & it could be partially utilised as follows (though I'm not suggesting this as the best option)

    1. Formula in F2 copied...
  14. Replies
    8
    Views
    127

    Re: Code for character allowance in cell

    Just wondering why you don't use Excel's built-in Data Validation as suggested by Dante? With that you can include your message heading and text via the 'Error Alert' tab in the Data Validation...
  15. Replies
    16
    Views
    287

    Re: Sum numbers between two specific cells

    No problem. Glad you got a successful outcome. :)
  16. Re: Vlookup not working and it's driving me MAD!!!

    Not trying to pick on you, but we have a set of rules & guidelines and everybody has to be bound by them. If urgency is an important factor, you should take note of 5g and 5h of the Forum Use...
  17. Re: Lowest decimal place value from a range of data

    Cheers. Thanks for the confirmation. :)
  18. Replies
    9
    Views
    173

    Re: count until "X" number appears again

    No problem. Look forward to hearing if it also works for you. :)
  19. Replies
    19
    Views
    292

    Re: get value from cell in a range

    That tells us that the is a double quote mark (") in L3. You should be able to see that unless there is formatting to make that mark the same colour as the background, or vice-versa. In any case, we...
  20. Re: VBA: If Range Contains Cell Value Copy than del

    You're welcome. Thanks for letting us know. :)
  21. Re: Vlookup not working and it's driving me MAD!!!

    In relation to this comment, please refer to #4 of the Forum Rules, especially the second paragraph.
  22. Replies
    3
    Views
    100

    Re: Countif no duplicates

    A very minor thing but you could save a little processing by removing that red $
    For example, in row 4 of your sample data, the fact that the logical test in your if statement is TRUE, means that...
  23. Replies
    8
    Views
    127

    Re: Code for character allowance in cell

    Try this Worksheet_Change event code. To implement ..
    1. Right click the 'MC LIST' sheet name tab and choose "View Code".
    2. Copy and Paste the code below into the main right hand pane that opens...
  24. Re: Same Data (date) Validation List for 2 cells; 1 cells to be greater than other cell

    Would this be any use?
    I have my Start Date Validation cell as A1 on Sheet2 and End Date DV cell as A2 on Sheet2.

    On Sheet 1 I have the list of dates in A1:A24 & formulas as shown, copied down.
    ...
  25. Replies
    9
    Views
    173

    Re: count until "X" number appears again

    If you are interested in a formula that doesn't require the Ctrl+Shift+Enter confirmation and also doesn't matter if there were blanks within the column A numbers then you could try this. Like...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4