jeudi 11 février 2021

If the first cell is empty do this, else do this vba

I have the following excel sheet:

enter image description here

Let's say I will filter on B column, looking for "b".

We have the following result:

enter image description here

How can I do the following interrogation:

if the first cell after the header is empty(in this case A7) do nothing
else
do this
end if

How can I check if the first cell after the heading is empty? Because the cell number will always be different.

Aucun commentaire:

Enregistrer un commentaire