isempty(range("a1").value) will work on a single cell.

That's why Jim used application.counta() for multiple cells.

JMay wrote:

Jim - I opened a new workbook - made no entries into sheet1 (the
activesheet)..

From the immediate Window I entered:
set rng = Activesheet.Range("G1:G5")
? rng.address
$G$1:$G$5
? isempty(rng)
FALSE << WHY???

TIA,
Jim

"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

--

Dave Peterson