View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paqogomez@gmail.com is offline
external usenet poster
 
Posts: 4
Default Basic question for blank column

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