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!
-
Excel Cell Tracker
I needed code to track previous cell location. It tracks previous and current cell by row and column. If user selects a range of cell it captures the left upper cell address. I am using this do to the fact that excel does not have a keypress event for worksheet. Global CellTracker(1, 1) As...- gtejas
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
need code to iterate Excel query table properties
Looking for help with the following: Sub ListQueryTableProperties() Dim ws As Worksheet, P As propterty Dim wsQry As QueryTable Set ws = Worksheets("Sheet4") Set wsQry = ws.QueryTables(1) For Each P In wsQry.Properties Debug.Print P.Name; Tab; P.Value...- gtejas
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
