Any Excel VBA Experts out there?
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