Search results for query: *

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...

True, but for the properties that are applicable it would be much less hassel to loop thru them and let the loop generate a report instead of listing them out one by one. They are in a object container somewhere and I am using a computer. But for now I just keep writting them out on the chalk...

All properties. AdjustColumnWidth, Application, BackgroundQuery, CommandText, CommandType, Connection, Creator, Destination, EditWebPage, EnableEditing, EnableRefresh, FetchedRowOverflow, FieldNames, FillAdjacentFormulas, ListObject, MaintainConnection, Name, Parameters, Parent, PostText...

Office Pro 2003 Yes I have found that there is not QueryTable.Properties. What I was hoping that someone might have a work around.

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...