anyone like writing macros? or know where i could findout how to write one
for this?

im after one that will do the following, with a button;

Sheet name = Totals
unhide colum A
Select Cells A2:J84
Select>Tools>Options>View>Showplaceholders
Select A1>dropdown>Show
hide colum A
Select>Tools>Options>View>Hide all
End

or does anyone know if this will make my rows auto hide or show when data is
on them? colum A has =IF(OR(B2="",B2=0),"Hide","Show) guess i can test it
while i wait :)

Thanks again everyone!

Steve