Consulting

Results 1 to 3 of 3

Thread: Help with VBA Code

  1. #1

    Help with VBA Code

    Hello! I need some help making VBA Code. I don't know the best way to do it.

    So I want to hide columns and rows that don't have any values in them. I have VBA Code that can do that, but it hides the columns and rows that have text in them as well.

    Do you guys know how I would go about doing this? Basically, I want columns and rows on an excel sheet to be hidden if their values add up to zero and they have no cells with text. However, if the columns or rows have cells with text or if their values are greater than zero, then I want the column/row to stay.

    Thank you!

  2. #2
    VBAX Expert
    Joined
    Apr 2005
    Posts
    741
    Location
    I think it might help if you attach your problematic workbook. Strip personal data if required.
    Your explanation suggests that all data could be hidden with the right circumstance.

  3. #3

Tags for this Thread

Posting Permissions

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