Consulting

Results 1 to 3 of 3

Thread: Delete Columns with blank or zero in total

  1. #1
    VBAX Regular
    Joined
    May 2016
    Posts
    69
    Location

    Delete Columns with blank or zero in total

    Hi Everyone,

    I have VBA code that takes certain filters in a pivot table and creates separate workbooks from it.
    In those newly created workbooks, I need to take all columns that contain a total of zero or blank and get rid of that column.
    I need the code to start in cell C & last row of the pivot table to that same row & last column of the pivot table, and analyze those cells for zeros or blanks and get rid of those columns.

    Please help

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Cross posted.

  3. #3
    VBAX Regular
    Joined
    May 2016
    Posts
    69
    Location
    Cross Posted, but I marked it as resolved on the other site due to a lack of response.
    So, technically I had one active posting and wasn't wasting anyone's time on the other site.

Posting Permissions

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