Posted to microsoft.public.excel.programming

Tre_cool[_18_] Tre_cool[_18_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
basic question	M121385	New Users to Excel	4	May 6th 08 06:22 PM
Basic question...sorry	jen the runner	Excel Worksheet Functions	11	September 18th 07 12:12 AM
Visual Basic code to find next available (blank) row in a spreadsh	TB	Excel Programming	2	July 15th 05 08:01 PM
Too Basic A Question	dave	Excel Programming	6	October 26th 03 03:57 PM
Basic VBA question	Henrik[_2_]	Excel Programming	2	October 25th 03 12:23 AM

All times are GMT +1. The time now is 01:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us