• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Keep getting object undefined....

I

Ipek

New Member
I keep getting object undefined on the below line of code?
If Target.PivotCell.RowItems(Target.PivotCell.RowItems.Count).Parent.SourceName = "DEPT_CATEGORY_DESC" Then
GetCategoryLevelData Target, DEPT, CatgGrp, Category
Sheet3.Activate
Exit Sub
End If

just curious, do i need to have below defined in a variable:
Target.PivotCell.RowItems(Target.PivotCell.RowItems.Count).Parent.SourceName

if yes, what type of variable that would be?
 
Hi ,

I am not sure about this , since I do not have Excel 2010 or later ; however , can you try changing your first line of code to :

If Target.PivotCell.RowItems.Item(Target.PivotCell.RowItems.Count).Parent.SourceName = "DEPT_CATEGORY_DESC"

Narayan
 
You must log in or register to reply here.
Back
Top