I have a sheet on which a group of cells expects an entry, either text or number. These can be 5 or 6 rows deep by 2 across.
Sometimes, only 5 of the rows have to be used and I would, on such an occasion, like to be able to code it in such a way as to hide the sixth row.
I have tried to use Entirerow.Hidden but no matter how I try I get an error.
In this case, the code runs:-
If cells(6,2)="" then
Range("A14").Entirerow.Hidden = true
else
Range("A14").Entirerow.Hidden = false
end if
This results in the error "Unable to set the hidden property in the Range class"
I'd be grateful if someone could point me in the right direction for clearly the Range part of the instruction is wrong.