+ Reply to Thread
Results 1 to 2 of 2

select range of pivot table to change number format

  1. #1
    Forum Contributor
    Join Date
    10-16-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    112

    select range of pivot table to change number format

    I'm trying to create a macro to select the range of the pivot table automatically but I have a blank column in Column C so I can't use the code below

    The range should be B5:E33 for this example

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    10-16-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: select range of pivot table to change number format

    I found this code that fins the last row in a column, but how can I change it to select the last column and last row starting from B5

    Please Login or Register  to view this content.

+ Reply to Thread

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