We help IT Professionals succeed at work.

simple task with macro, but not catching right spots

I recorded a macro and set it to use relative ref. ,but it seams to be using exact addresses. I want to use the macro on several sheets, so I don't think I want the sheet name in the macro. See attached.  Thanks.
edition-cleaner.xlsx
Comment
Watch Question

Top Expert 2008

Commented:
You need to load as an xlsm file if you want us to see the macro. Or you can post the code.

Thomas
CERTIFIED EXPERT
Top Expert 2010

Commented:
Be nice to this guy, he's family :)
Top Expert 2008

Commented:
Come on Patrick, did I go zorvek on him?

T
CERTIFIED EXPERT
Top Expert 2010
Commented:
David,

If what you really want to do is make the row labels repeat in the PivotTable, this can be done without a macro if you are using Excel 2010 or later.  If you right-click in the row labels area and select Field Settings, go to the Layout & Print tab on the Field Settings dialog.  Check the box for Repeat Item Labels.

If that is not what you wanted, or if you are using Excel 2007 or earlier, then please post the code you recorded (or re-post the file as an xlsm), as Thomas suggested.

Patrick

<aside to Thomas: :) >

Explore More ContentExplore courses, solutions, and other research materials related to this topic.