+ Reply to Thread
Results 1 to 2 of 2

using VBA to hide columns and rows that do not have cells with a specific format

  1. #1
    Forum Contributor
    Join Date
    04-30-2008
    Posts
    105

    using VBA to hide columns and rows that do not have cells with a specific format

    Ok, I was working on something earlier that I posted here that takes values that end in 000 and 000) and highlight them in yellow and bold them, this was the final code:

    Please Login or Register  to view this content.
    It does what I want, goes through pivottables in 6 different worksheets and formats those cells that have numbers ending in 000 or 000). I'm now trying to write a macro that will go through those worksheets and if any row in that pivottable has a highlighted/bold cell, to go into column B of that specific row and highlight that cell yellow as well. Once it does that, the macro has to hide the rows in the pivottable that aren't highlighted or bold and also the columns that aren't highlighted or bold.

    Column B contains project names and basically I want these macros to go through these tables and only show the costs that end in 000 or 000) along with the project name that the cost was allocated to. I hope this makes sense. I've tried a few lthings but can't quite get them to work.

  2. #2
    Forum Contributor
    Join Date
    04-30-2008
    Posts
    105
    In case you're all curious, this is what I came up with to highlight the project names in column B if any value in that corresponding row is highlighted and bold:

    Please Login or Register  to view this content.
    It works just fine but only in the active worksheet, it doesn't actually go through all of the sheets I need it to go through. In the code I only had it search for cells that were highlighed yellow, this was because any cells that are highlighted yellow will also be in bold.

+ 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