Posted to microsoft.public.excel.programming
|
|
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
|