Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    230

    [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.

    ...
  2. 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:

    ...
  3. Replies
    4
    Views
    196

    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>"
  4. Replies
    4
    Views
    196

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

    I'd use something like:

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

    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...
  6. Replies
    21
    Views
    2,501

    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...
  7. Replies
    5
    Views
    968

    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...
  8. 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...
  9. 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...
  10. Replies
    20
    Views
    1,086

    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...
  11. 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...
  12. Replies
    25
    Views
    1,756

    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...
  13. Replies
    5
    Views
    1,173

    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...
  14. 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...
  15. Replies
    6
    Views
    647

    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...
  16. Replies
    6
    Views
    647

    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.
  17. 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...
  18. Replies
    12
    Views
    1,356

    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...
  19. Replies
    12
    Views
    1,356

    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...
  20. Replies
    2
    Views
    383

    For large datasets, a database is better suited...

    For large datasets, a database is better suited to tasks like this than Excel - a SQL command could extract the unique addresses extremely quickly. If you have to use Excel, you could try getting...
  21. Replies
    12
    Views
    1,356

    Hi, I read your post to mean that if you have...

    Hi,

    I read your post to mean that if you have a list that if you have address a,b,b,b,c,d,d,e,f,f,f,g you would end up with a,c,e,g after all the duplicate ones had been removed. Here's some code...
  22. Replies
    2
    Views
    717

    When I've come across similar problems in the...

    When I've come across similar problems in the past, as well as jscher's suggestion, here are some other things that I've tried and have worked at various times (even though they don't necessarily...
Results 1 to 22 of 23