I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbNoBlank

Unfortunately Excel © lacks a function which returns all non-blank input cells. I have developed two functions which resolve this: sbNoBlank can be used in worksheets, sbNoBlankVBA via VBA.

20101005_PB_01_sbNoBlank_Screen

If you are interested in downloading an Excel © sample file which created the output shown above, go to my Download page, please.

20101005_PB_01_sbNoBlank_Code
20101005_PB_01_sbNoBlankVBA_Code
Sulprobil   Get it done   Contact   Disclaimer   Download