Re: Basic question for blank column
- From: paqogomez@xxxxxxxxx
- Date: 29 Nov 2005 12:05:51 -0800
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/default.asp?url=/library/en-us/dv_wrcore/html/wrgrfexcelrangeobject.asp
or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrtskhowtosearchfortextinworksheetranges.asp
.
- References:
- Basic question for blank column
- From: Tre_cool
- Basic question for blank column
- Prev by Date: Re: spreadsheet range selection
- Next by Date: Max size of variable?
- Previous by thread: Basic question for blank column
- Next by thread: Re: spreadsheet range selection
- Index(es):
