How does this work for you? Columns("A").NumberFormat = "0.00%" I've always found that if I have to do some VBA, then I create and record a new macro, do what I want, then edit the macro to find out how Excel creates the code. "we must lose precision to make significant statements about complex systems." -deKorvin on uncertainty

Thank you

Check here "People who never make mistakes, never do anything." My blog http://toddsnotsoamazinglife.blogspot.com/

Just create your dts package with sql server and then have look at this article. http://sqldev.net/DTS/DotNETCookBook.htm[^] Article is about calling dts packages programatically with .NET.

What your looking for is the HttpWebRequest[^] class. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

I did stop and checked the high and low Latitude/Longitude and all 4 look fine, but I get the same result with a radius of 1 mile and a radius of 12 miles. I think the DB I'm using is wrong. Do you know where I can find another zip code DB? Thanks again, Martin

You need to bind the SelectedValue property to the id field also. Then you get the value by: memId = ComboBox1.SelectedValue

Yeah, Google for "vb.net word automation"[^] and you'll come up with over 88,000 hits. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

How about if I want to remove ALL rows that dont' meet that criteria Table1.Select(" Name = 'Adam' ") Dim rows() as DataRow rows = Table1.Select(" Name = 'Adam' ") If rows.Length > 0 Then Table1.Rows.Remove(rows(0)) End if Thanks, Martin