Results 1 to 16 of 16

GetPivotData

Threaded View

GeorgY GetPivotData 12-01-2009, 08:47 PM
DonkeyOte Re: GetPivotData 12-02-2009, 08:00 AM
GeorgY Re: GetPivotData 12-02-2009, 09:22 AM
romperstomper Re: GetPivotData 12-02-2009, 09:33 AM
GeorgY Re: GetPivotData 12-02-2009, 09:44 AM
romperstomper Re: GetPivotData 12-02-2009, 09:58 AM
GeorgY Re: GetPivotData 12-02-2009, 10:27 AM
romperstomper Re: GetPivotData 12-02-2009, 10:46 AM
GeorgY Re: GetPivotData 12-02-2009, 11:23 AM
romperstomper Re: GetPivotData 12-02-2009, 11:25 AM
GeorgY Re: GetPivotData 12-02-2009, 11:28 AM
GeorgY Re: GetPivotData 12-02-2009, 11:31 AM
romperstomper Re: GetPivotData 12-02-2009, 11:38 AM
GeorgY Re: GetPivotData 12-02-2009, 11:40 AM
romperstomper Re: GetPivotData 12-02-2009, 11:45 AM
GeorgY Re: GetPivotData 12-02-2009, 11:48 AM
  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