Hi Guys,
Apologies for repeating an old question, but I am trying to build my spreadsheet so that it auto-hides any rows were there is zero premium outstanding for a client.
I had gone through previous answers, and I had tried to lift and amend some VBA code to achieve this. However, somewhere within this code or the way I've implemented it, there is an error, because it's not showing of hiding any rows.
Can you please take a look at the attached and fix it (in order to hide all rows with a zero in column F), and maybe point out what I was doing wrong or omitting. I have anonymised my data.
Many Thanks
John
Apologies for repeating an old question, but I am trying to build my spreadsheet so that it auto-hides any rows were there is zero premium outstanding for a client.
I had gone through previous answers, and I had tried to lift and amend some VBA code to achieve this. However, somewhere within this code or the way I've implemented it, there is an error, because it's not showing of hiding any rows.
Can you please take a look at the attached and fix it (in order to hide all rows with a zero in column F), and maybe point out what I was doing wrong or omitting. I have anonymised my data.
Many Thanks
John