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 dencom 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: bulldawg1515
- Order by date
-
Get Cell Reference of GetPivotData
I haven't looked at the TableRange properties yet but will do so. The reason I want the Watch to be on the cell being referenced is because the referenced cell is in a separate sheet in a workbook of about 30 sheets. With the watch on the referenced cell, I can double-click on that cell in the...- bulldawg1515
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Get Cell Reference of GetPivotData
I want to put a Watch on the cell that it references. Maybe there is a way that I can do this with GetPivotData instead???- bulldawg1515
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Get Cell Reference of GetPivotData
Is there any way to get the cell reference that a GetPivotData function is referring to? I have cells that equal GetPivotData from a Pivot Table on another sheet within the workbook. I want to be able to find a way to find the actual cell reference that the function is referring to. Is this...- bulldawg1515
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
String parsing
I'm hoping this is something simple that I'm just overlooking but I can't figure it out. I'm trying to parse a string of text to determine how many leading spaces there are. For example, I have string " abc" and I want to be able to determine that there are three spaces at the start of this...- bulldawg1515
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
