Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. If the number varies but is always between "RC"...

    If the number varies but is always between "RC" and the "(" character, this will find any number:
    =MID(A1,FIND("RC",A1)+2,FIND("(",A1)-FIND("RC",A1)-2)
  2. [SOLVED] I look forward to seeing your alternate approach...

    I look forward to seeing your alternate approach zeddy!

    In the meantime, I've altered my code so that each file is opened only once so it'll be quicker, but this will probably only work with...
  3. [SOLVED] Hi, I think the attached does what you require -...

    Hi, I think the attached does what you require - with a little help from Hans Vogelaar!
  4. If I understand what you're after, since a...

    If I understand what you're after, since a textbox will accept any input by default, I think that you just need to remove the checking for numbers only, so you'll need to declare id as a String and...
  5. I've amended your file so that it now does what I...

    I've amended your file so that it now does what I think you want it to do.

    (I've added Option Explicit in the code as I like working that way, but you may want to remove that.)
  6. In the attached file, the macro requests a...

    In the attached file, the macro requests a filename, opens the two files and does a comparison. To open the two samples you sent, just use "002_Daily" as the filename when requested. The macro...
  7. Replies
    3
    Views
    319

    [SOLVED] You could allocate a value based on the cell...

    You could allocate a value based on the cell colour and then sort by that. I've done it with VB standard colours, but you could use the RGB values of your particular colour to allocate them, e.g.

    ...
  8. Rather than creating the forms on the fly, you...

    Rather than creating the forms on the fly, you could just restrict the print area of the Forms sheet by adding some code like this before the End Sub in the CreateForm macro:

    ...
  9. Replies
    4
    Views
    251

    Try using the tag instead: ...

    Try using the <p> tag instead:


    StrBody:="<body><p>Dear " & StrCCAddr & _
    "</p><p></p>Attached please find Management Report for Br1" & _
    "<br><br>" & "Regards</body>"
  10. Replies
    4
    Views
    251

    I'd use something like: StrBody:="Dear " &...

    I'd use something like:

    StrBody:="Dear " & StrCCAddr & "<br>" & _
    "<body>Attached please find Management Report for Br1" & _
    ...
  11. Replies
    9
    Views
    713

    I adapted the script I found here...

    I adapted the script I found here like this:

    Function LaunchIE(strURL As String)
    Dim shell
    Set shell = CreateObject("WScript.Shell")
    shell.Run """C:\Program Files\Internet...
  12. Replies
    21
    Views
    3,274

    I've had a look at this and I think I know what's...

    I've had a look at this and I think I know what's happening, but am not sure how to fix it. I'm sure Maudibe or one of the other superstars on this site will have a solution though!
    First the bits I...
  13. Replies
    5
    Views
    1,612

    I've prepared the attached revised file which...

    I've prepared the attached revised file which does the things I think you require, except I wasn't sure of exactly what should map to the summary fields, but you should be able to amend the macro to...
  14. The two commas are because that's where you would...

    The two commas are because that's where you would put row number if you were looking for a specific row, but you just want to know if there's something anywhere in the column so it's left blank.
    The...
  15. I tried a slightly different approach and can get...

    I tried a slightly different approach and can get it to work with numbers but can't get it to work with letters; instead of an "a" character to indicate leave I have had to use a "1" (but it could be...
  16. Replies
    20
    Views
    1,586

    One method would be to create a copy of the sheet...

    One method would be to create a copy of the sheet you want to print, remove the shading from that sheet and print it, then delete the unwanted sheet. Substitute Sheet1 with the name of the sheet...
  17. If you substitute this section to the following,...

    If you substitute this section to the following, it will check if there are any blanks and tell the user where the problem is:

    'COPY SOURCE DATA INTO ARRAY VARIABLE (DATA ROW)

    For i = 0 To...
  18. Replies
    25
    Views
    2,683

    I have broken the problem down into bits in the...

    I have broken the problem down into bits in the attached file. Columns A & B are a set of ascending dates and some random numbers. Column C checks if the date is the first or last of the month and...
  19. Replies
    5
    Views
    1,654

    Not an ideal solution, but Copy/Paste...

    Not an ideal solution, but Copy/Paste Special/Paste Special/Comments will move the comment to another cell, but you're left to delete the original comment because Paste Special doesn't work with...
  20. I suggest you use Advanced Filter rather than...

    I suggest you use Advanced Filter rather than Autofilter.

    Insert a few rows above the data you want to filter and copy your column headers to the first row of this space. In the second row in...
  21. Replies
    6
    Views
    923

    Hi Steve, I saw that the slash was missing but...

    Hi Steve,

    I saw that the slash was missing but assumed it was a typo since all the others had it in... Only gonzalezw can know for sure. I should have mentioned this in my post but was rushed as I...
  22. Replies
    6
    Views
    923

    Nested IFs are one solution

    I don't know that you can do it with conditional formatting, but could do it with formulae using a few nested IFs as per the attached file.

    Hope this helps.
  23. The K.I.S.S. solution

    38816I've attached a really simple solution - adding in a Due Date column so that it shows when that task is due. I've also added a bit of conditional formatting to that columns so that if the task...
  24. Replies
    12
    Views
    1,767

    This should work for anything where column A and...

    This should work for anything where column A and column B both match (as per your sample code). Steve's option 3 will also work, or if you post a sample section of your spreadsheet I can examine why...
  25. Replies
    12
    Views
    1,767

    Apologies. I'd cut a bit too much from the...

    Apologies. I'd cut a bit too much from the original, and while it worked with that test sample, it doesn't work in all circumstances... This should work properly now:

    Sub RemoveDups()
    '
    Dim i As...
Results 1 to 25 of 29
Page 1 of 2 1 2