Search:

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

Search: Search took 0.01 seconds.

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

    ...
  2. Replies
    4
    Views
    167

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

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

    I'd use something like:

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

    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...
  5. Replies
    30
    Views
    2,167

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

    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...
  7. 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...
  8. 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...
  9. Replies
    20
    Views
    998

    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...
  10. 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...
  11. Replies
    25
    Views
    1,561

    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...
  12. Replies
    5
    Views
    1,044

    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...
  13. 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...
  14. Replies
    6
    Views
    574

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

    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.
  16. 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...
  17. Replies
    12
    Views
    1,202

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

    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...
  19. Replies
    2
    Views
    359

    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...
  20. Replies
    12
    Views
    1,202

    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...
  21. Replies
    2
    Views
    701

    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 21 of 22