Hi, I can't seem to think of a line for this. I want to check a column
to see if it's blank or not in code. I know that in the worksheet
function I can do =COUNTA(W:W)=0, but what's the vb code for it?

Thanks
Trevor


--
Tre_cool
------------------------------------------------------------------------
Tre_cool's Profile: http://www.excelforum.com/member.php...o&userid=26416
View this thread: http://www.excelforum.com/showthread...hreadid=489185

If range.IsEmpty(ActiveCell) then
do stuff
end

IsBlank is also an excel function

For info on how to declare a range in VB poke around...
http://msdn.microsoft.com/library/de...angeobject.asp
or
http://msdn.microsoft.com/library/de...heetranges.asp

I can't get this to work. I just want to check if column W is empty or
not. Please help.


--
Tre_cool
------------------------------------------------------------------------
Tre_cool's Profile: http://www.excelforum.com/member.php...o&userid=26416
View this thread: http://www.excelforum.com/showthread...hreadid=489185

Hi Tre_cool,

Try:

If Application.CountA(Columns("W")) = 0 Then

---
Regards,
Norman


"Tre_cool" wrote in
message ...

I can't get this to work. I just want to check if column W is empty or
not. Please help.


--
Tre_cool
------------------------------------------------------------------------
Tre_cool's Profile:
http://www.excelforum.com/member.php...o&userid=26416
View this thread: http://www.excelforum.com/showthread...hreadid=489185

THanks Norman..That worked!

Trevor


--
Tre_cool
------------------------------------------------------------------------
Tre_cool's Profile: http://www.excelforum.com/member.php...o&userid=26416
View this thread: http://www.excelforum.com/showthread...hreadid=489185