how to write a code to select a range excluding Null String

[msand]

There is a range in excel spreadsheet, part of it is Null String (""). I want to write a code to select the range excluding the Null String. I am not sure how to do this. Any thoughts?

Example:

In Range (A1:B3), Cell A3, B3 are Null String. If I use Selection.CurrentRegion.Select, the range I selected still includes the null string A3, B3. How to exclude them?

 

[Parra]

Re: how to write a code to select a range excluding Null Str

I think you should move this question to the Excel Board.