Spreadsheets and hiding/deleting empty columns

[Nathanx7]

Hello folks, I have a problem I can't figure out. I'm trying to write a macro that will examine a column and if no data is in the column, hide the column (or delete if "Hide" is impossible) and the column before it.

Example:

Column A - Date of Sale
Column B - Type of Sale
Column C - Business name
Column D - Salesperson's name
Column E - Salesperson's ID number
Column F - Cold/Warm call made?
Column G - Signature
Column H - Contact call?
Column I - Signature
Column J - Spoke to Contact?
Column K - Signature
.... etc until the last column Y is reached ending with the signature for project X


The report that my system generates shows EVERYTHING and it's a very long document. Even in landscape, it's three pages across--and Heaven help you if you have to run it for an entire month! It's almost two hundred pages!

So to cut down on the pages and the searching, I'm trying to create a macro that will hide the signature column if contains no values other than a dash "-". In addition, it hides the column before it.

So if Column K had zero signatures and only a single dash in each cell, the macro would remove that column and column J.

Can this be done 'cuz I can't figure it out to save my life.

[mehmetcik]

I would need to use a macro

The question is how would you trigger it?

To keep it simple I would clear all cells that contain just a dash

Then I would look at each column of data and use counta to find the number of non blank cells in my data

that would allow me to hide the two relevent columns.

this should be quite easy. [ Famous Last Words ].

I will need to use an array to store the columns that you want tested and hidden, as you haven't posted your spreadsheet.

So you may need to modify the array.

Please Login or Register  to view this content.

[Nathanx7]

Gah, my macro wasn't even close! This is perfect! Works like a charm!

If this forum had a donate button, you'd get the full contents of my savings account! $18 AND 42 cents!

Seriously, you're a rockstar. Thanks again.