Forum Discussion

Copper Contributor

Jul 27, 2018

Issue with excel on a shared computer

We have a shared computer with different users in our department. The first user that first used that computer does not have issues. I myself after creating the second user faced an issue with exce...

Macros and VBA

Volker Wollenweber

Copper Contributor

Jul 30, 2018

To clarify my issue:

I recorded a macro.

The following action was done during recording:

wrote "Hallo" into Cell A1.

Here is what the VBA editor gives to me:

Sub Macro1()
'
' Macro1 Macro
'

'
ShowDrillIndicators. = "Hallo"
Range("A2").Count
End Sub

I never saw or read the command "ShowDrillIndicators

Damien_Rosario

Silver Contributor

Jul 30, 2018

Hi Volker

I'm not sure what's happening with the way it's not doing what you expect, but at the very least ShowDrillIndicators is a legit thing for PivotTable.

https://www.google.com.au/search?dcr=0&source=hp&ei=-ZtfW-vgDtrk-Aa6rK2ICw&q=vba+showdrillindicators&oq=ShowDrillIndicators&gs_l=psy-ab.1.0.0i5i30k1.1278.1278.0.3218.1.1.0.0.0.0.284.284.2-1.1.0....0...1c.2.64.psy-ab..0.1.283....0.G7lMHVvnxlE

Maybe a coding expert here will know why one user is fine and the other is not? Hopefully you get it resolved soon!

Cheers

Damien