Macro Variable doubt

[karti1986]

Dim sel As Long
Range("B9").Select
Range(Selection, Selection.End(xlToRight)).Select
sel = Selection.Columns.Count
ActiveSheet.PivotTables("EventPivot").PivotFields("Hosts").AutoSort _
xlDescending, "Count of Incident.Incident ID", ActiveSheet.PivotTables( _
"EventPivot").PivotColumnAxis.PivotLines("sel"), 1


"sel" is this even possible here? Yes, it didnt work.. Please let me know how to make it work with any syntax corrections
sorry if Im dumb.

Thanks in advance!!

Regards
KG

 

[karti1986]

Can anyone help me on this, please?

 

[Rick Rothstein]

Dim sel As Long
Range("B9").Select
Range(Selection, Selection.End(xlToRight)).Select
sel = Selection.Columns.Count
ActiveSheet.PivotTables("EventPivot").PivotFields("Hosts").AutoSort _
xlDescending, "Count of Incident.Incident ID", ActiveSheet.PivotTables( _
"EventPivot").PivotColumnAxis.PivotLines("sel"), 1

"sel" is this even possible here? Yes, it didnt work.. Please let me know how to make it work with any syntax corrections
sorry if Im dumb.

Try removing the quote marks from around the variable name (sel) and see if that works.

 

[karti1986]

Thanks for the reply Rick

Tried that, it throws an error saying "Invalid Procedure Call or Argument"

Any Idea?

Thanks Again!

Regards
KG

 

[Rick Rothstein]

Thanks for the reply Rick

Tried that, it throws an error saying "Invalid Procedure Call or Argument"

Sorry, but I don't program with PivotTables... all I did was guess given that encasing variable names in quote marks hides the fact that they are variable names (and not just text) from the VB compiler. I don't know what kind of argument the PivotLines property is supposed to be looking for, but what you assigned to the "sel" variable appears not to be it. Hopefully someone with PivotTable experience will be along who can advise you better on this.

 

[karti1986]

Sorry, but I don't program with PivotTables... all I did was guess given that encasing variable names in quote marks hides the fact that they are variable names (and not just text) from the VB compiler. I don't know what kind of argument the PivotLines property is supposed to be looking for, but what you assigned to the "sel" variable appears not to be it. Hopefully someone with PivotTable experience will be along who can advise you better on this.

Im glad that you tried helping me! Thanks Rick!!

 

[karti1986]

Anyone??

 

[karti1986]

I badly need this to work!! any alternative suggestions are welcomed as well!! Thanks

 

[Rick Rothstein]

I badly need this to work!! any alternative suggestions are welcomed as well!! Thanks

Why don't you post your original message in a new thread, but this time make the thread's title "PivotTable expert needed".

 

[karti1986]

will do Rick! thanks!