How can I drilldown/showdetails with Cells rahter than Range

[gilsa]

Hi All,
I have the Cells(Row, Column) value, which I need to use to show the details of this cell value in a specific pivot table.

As far as I could see the most common usage is Range and then selection.showdetails = true.

I tried using the blow unsuccessfully:
Cells(FindRow.Row, FindColumn.Column).Select
Selection.ShowDetails = True

Can anyone suggest how to do it with Cells()?

Your support is highly appreciated!

Gil.

 

[Jerry Sullivan]

Hi Gil,

You have a syntax error or typo in your example... you are using the plural .ShowDetails, the Method is .ShowDetail.

The method will work similarly whether you use .Range() or .Cells(). In both cases the expression evaluates to a Range Object (there is no Cell Object or Cells Object- .Cells is a Property).

So both these statements should result in the same action....

 ActiveSheet.Range("B3").ShowDetail = True

 ActiveSheet.Cells(3, 2).ShowDetail = True

If you already have the Range Object assigned to the FindRow variable, then this simpler expression may be used.

 FindRow.ShowDetail = True

 

[gilsa]

Hi Jerry,
Thanks for your clarification and support!

Cheers,
Gil