lo all,
I had previously bookmarked some VBA for this, but I can't seem to get it to work in this instance. Can someone show me what I'm doing wrong?
The cell I set to the "MrktrFieldName" is the cell I'd like to identify in the VBA to filter the "Job Rep" field of the IncomePivot.
Thank ya much
Please Login or Register to view this content.
This is hardly descriptive of the problem. If it errors, what line is highlighted in the debugger and what is the error description?Originally Posted by Miskondukt
Where do you do you set that cell. If "MrktrFieldName" is a named range, then use this syntax to reference it.cell I set to the "MrktrFieldName"
Range("MrktrNameField")
I think you would call your UpdatePivotFieldFromRange procedure like this...
UpdatePivotFieldFromRange "MrktrNameField", "Job Rep", "IncomePivot"
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks