Results 1 to 8 of 8

Thread: vb/excel question with ranges

Threaded View

  1. Mar 12th, 2003, 08:23 AM #1
    kleinma
    kleinma is offline

    Thread Starter
    I'm about to be a PowerPoster! kleinma's Avatar
    Join Date
    Nov 2001
    Location
    NJ - USA (Near NYC)
    Posts
    23,373

    vb/excel question with ranges

    I have a spreadsheet and was asked to write a VB Macro that will scan the spreadsheet and change the BG color of any cells that are not filled.. IE have a vakue of ""

    so i can do this easy enough i think... but i need to find the limits of the sheet.. so i figure i have to scan down and scan across to find the ends of the data.. for example the sheet looks like this
    VB Code:
    1. 212.44.42.827       done    done           done

    2. 741.171.456.747     done    done    done   done

    3. 123.14.4.487                done    done

    4. 173.14.46.681       done    done    done   done

    5. 113.142.46.888      done                   done

    6. 583.44.46.833       done    done    done
    so only where "done" is missing i want to change the BG color... any help on this??? I don't do much excel automation.. i am not so familiar with excels methods and properties
    Last edited by kleinma; Mar 12th, 2003 at 08:27 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width