Thank you, Jim
Nice trick.

"Jim Cone" wrote in message
...

Application.CountA(rngToBeFilled)
(you don't need to select the range)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"dan"
wrote in message
I need a VBA code to ensure the range to be filled, is empty to begin.
I will select the range, test if the range is empty, then proceed
accordingly.
Thanks