Any Excel VBA Experts out there?

Posted by Anonymous PM | on Thu, 22/04/2010 - 11:36 920 15 comments | report

We have Office 2007 and i have a spreadsheet in excel where we enter income details in various boxes which are then linked to boxes below which lists all the relevant income. I want rows below to only appear if they actually have a figure in, so if they have a value of 0 then i want that row to be either hidden or have a height of 0.

I've discovered that i cant do this via conditional formatting however i can apparently do it using a VBA script. Does anyone know how to do such a script?

Many thanks in advance

Comments

There are 15 comments. Login or register to view them.

Hiding empty rows

fisch4billf | Thu, 22/04/2010 - 12:50

Problems...

Anonymous | Thu, 22/04/2010 - 13:18

Script in a better format...

Anonymous | Thu, 22/04/2010 - 13:19

Script reworked

fisch4billf | Thu, 22/04/2010 - 13:46

Dummy sheet

Anonymous | Thu, 22/04/2010 - 15:14

Script creation

fisch4billf | Thu, 22/04/2010 - 15:32

Script

Anonymous | Thu, 22/04/2010 - 15:50

Try changing to this

ACDWebb | Thu, 22/04/2010 - 16:17

I cant get this to run...

Anonymous | Thu, 22/04/2010 - 17:06

You shouldn't need to run it

ACDWebb | Thu, 22/04/2010 - 17:46

Re: Script

fisch4billf | Thu, 22/04/2010 - 18:05

Re: I cant get this to run

fisch4billf | Thu, 22/04/2010 - 18:45

WONDERFUL!

Anonymous | Fri, 23/04/2010 - 09:27

As Bill says

ACDWebb | Fri, 23/04/2010 - 11:34

Final change

fisch4billf | Fri, 23/04/2010 - 13:24