View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tre_cool[_18_] Tre_cool[_18_] is offline
external usenet poster
 
Posts: 1
Default Basic question for blank column


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