Results 1 to 2 of 2

Name Reference problem

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,974

    Name Reference problem

    I've got a macro manipulating a pivot table, and I'm having trouble selecting one part of my data range. The errant line from my macro is below.
    PivotFields("Data").PivotItems(" Revised Current Month Projected ").DataRange.Select
    The problem is that the title is formatted like this:
    (space)Revised(skip down a line)
     Current Month Projected
    , and I don't know how to put that into my code. Any help is highly appreciated.
    Last edited by jomili; 03-22-2011 at 04:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1