You can follow the discussion on Getting the Source Range of a Pivot Table with VBA without having to leave a comment. Cool, huh? Just enter your email address in the form here below and you’re all set.