+ Reply to Thread
Results 1 to 12 of 12

code tidying

  1. #1
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690

    code tidying

    is there anyway of tidying this code up
    is there such a think as a code tidier?
    im not sure but i think this looks a mess
    dont get me wrong it works great but it does seem excessive
    Please Login or Register  to view this content.
    thanks

  2. #2
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690

    Code to stop scroll

    please ignore this
    cat see how to delete
    Last edited by stevesunfold; 12-25-2008 at 10:28 AM.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello stevesunfold,

    This can be condensed by using the BorderAround method. There are four possible arguments: Line Style, Weight, ColorIndex, and Color. If can specify either Line Style or Weight, but not both. The same holds for Color Index and Color. Unless the inside Vertical, Horizontal, and diagonals have been set in the cells previously, you don't need to include them. This example is based on Excel 2003.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

  4. #4
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi leith
    getting an error
    compile error
    end select without select case

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello stevesunfold,

    Bad editing on my part. I didn't change a "Select" to "With". This should work.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Leith types faster than I think. The property is BorderAround:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi guys
    getting a run time error 438 from yours leith
    object doesnt support this property or method
    highlights this line
    Please Login or Register  to view this content.
    and on yours shg it only clears a few cells h11 to h26

  8. #8
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello stevesunfold,

    I am really doing good today - another typo. Should be...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

  9. #9
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    thanks for trying guys
    unfortunately leith that does the same as shg one
    i have to go offline now
    it is xmas day after all lol

  10. #10
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    and on yours shg it only clears a few cells h11 to h26
    Steve, do you see the line that clears cell contents in the code?

    Do you need help to edit it to clear other cells?

  11. #11
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi guys
    thanks for your efforts
    please find the attached this is how it should look after its cleared and thats how it looks after the huge original code
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    bump bump bump

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1