selecting non-blank cells

[XLlearner]

We have option of selecting blank cells in a range (GOTO and select blanks), do we have any option excel to select the nonblank cells. the cells contain only values and not formulae.

[VBA Noob]

Press F5 > special > constants

Select from Numbers, Text, Error or Logical

VBA Noob

[XLlearner]

thanks a lot it did work....

[VBA Noob]

Glad it helped

VBA Noob