I have an array A15:G63
, what I would like to do is create a button called 'Clear'
The purpose of the button is:
- Between
A15:G63
, if a cell has no values (usually the value input is a string) I would like to delete that row. It could be multiple rows.
For example: I enter the word 'HI' in A15:G55
, nothing in A56:G59
, and the word 'HELLO' in A60:G63
. I would like to delete rows 56-59.
How do I do that?
Thanks all.
Aucun commentaire:
Enregistrer un commentaire