Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: nashvillebill
- Order by date
-
VBA Excel - Read value of cell
Hear is some really simple code that returns an error 9 - subscript out of range error. Private Sub CommandButton1_Click() Workbooks("Distance Calculator Test").Sheets("Calculate").Range("G2").Font.Bold = True End Sub- nashvillebill
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA Excel - Read value of cell
I working on a project in which I am moving equipment from 400 locations to 400 other locations in the US. I have the longitude and latitude for each of the locations and I'm trying to find the nearest locations to move the equipment to. I'm using a trig formula in Excel 2007 to find the...- nashvillebill
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
