Results 1 to 16 of 16

GetPivotData

Threaded View

  1. #1
    Registered User
    Join Date
    12-09-2008
    Location
    Canada
    Posts
    79

    GetPivotData

    Hi guys, I've been programming for a while, but strangely never learned to use Pivot Tables. Recently I discovered how much work they can save me so I started using them. I'm still having trouble with the code though. Please take a look and tell me what I'm doing wrong:

        invPTWs.Activate
        Set fCell = Range("A2")
        Set lCell = Range("A65536").End(xlUp).End(xlToRight)
        Set invPTrng = Range(fCell, lCell)
    
        compWs.Cells.Clear
    
        compWs.Select
        Range("A1").End(xlToRight).Offset(0, 1).Select
        Selection.Value = "Forecast"
        ActiveCell.Offset(1, 0).Select
        ActiveCell.Value = Application.GetPivotData(invPTrng, "compWs.Cell(2,1) ATLANTIC")
    Attached Files Attached Files
    Last edited by GeorgY; 12-02-2009 at 02:16 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