Select Non Blank cells of ActiveSheet

If you want to replace or select non-blank cells on the particular columns in active sheet, use the below codes: 

 

Input:

I have selected Non blank cells on the Active Sheet and replaced with 1.

Result:

Leave a Reply

Your email address will not be published.