View Single Post
  #5   Report Post  
Huw Davies
 
Posts: n/a
Default

Good point, I sort of left you hanging there didn't I? Please accept my
aplogies. Anyway, the news I have is no better than last time. VBA stands for
Visual Basic for Applications, and is the programming language that sits
behind Excel (and all other MS Office products) that allows you to automate
what Excel does. "Automation" can stretch from the very simple, e.g. "When I
press the button with smiley face, turn all text red", to the horrendously
complex e.g. "Import this table, perform 6 million calculations, produce a
chart, publish it in powerpoint, then send an email, and finally wake me up
when you're done". It's not for the fainthearted, but it can be fun. It would
certainly be possible for it to start at the top of a sheet, and as it works
it's way down, to hide each blank row. I'm afraid I don't have the confidence
or the kind of experience you need to talk you through it on a newsgroup, but
I offer two suggestions. a) if you've time, nip out and get a book on Excel
VBA - not a big thick expensive one, but one for someone brand new to it that
will only cost a few pounds, and / or b) repost your question in the
programming newsgroup with a subject line like "code needed to automatically
hide blank rows" - there's loads of people in there who know all there is to
know about VBA and more importantly, know how to explain it better than I.

I'm really sorry it's not the answer you need, but it's the best I can offer.

Regards,

Huw.

"tamato43" wrote:

Do you know of a VBA format then?

"Huw Davies" wrote:

I don't think you can use conditional format to automatically hide rows that
are blank. It's either do it by eye using the "hide" option under Format |
Row menu, or by using VBA.

Huw.

"tamato43" wrote:

Hello All,

Does anyone know how to set a conditional format to hide a colum and/or row
if they are left blank?

Example:

I have a spreadsheet that imports info from another worksheet or file into
10 rows.
In some cases I only populate rows 1 through 5 leaving 6 through 10 blank,
So I'd like to hide those rows.

Please help.