Determining if certain row # is blank

's Computer Specifications

I would greatly appreciate any help in writing the necessary line(s) of code
to determine if a given row (e.g., 8) in the active workbook is completely
blank.
Thanks,
Bob

's Computer Specifications

this should return a zero if the row is blank:

application.counta(rows(8))
--

Gary

"Bob" <(E-Mail Removed)> wrote in message
news:F4CF998C-735E-44A6-984C-(E-Mail Removed)...
>I would greatly appreciate any help in writing the necessary line(s) of code
> to determine if a given row (e.g., 8) in the active workbook is completely
> blank.
> Thanks,
> Bob

's Computer Specifications

One way:

Dim bLine8IsBlank As Boolean
bLine8IsBlank = Application.CountA(ActiveSheet.Rows(8)) = 0

In article <F4CF998C-735E-44A6-984C-(E-Mail Removed)>,
Bob <(E-Mail Removed)> wrote:

> I would greatly appreciate any help in writing the necessary line(s) of code
> to determine if a given row (e.g., 8) in the active workbook is completely
> blank.
> Thanks,
> Bob

's Computer Specifications

JE - Thanks!

"JE McGimpsey" wrote:

> One way:
>
> Dim bLine8IsBlank As Boolean
> bLine8IsBlank = Application.CountA(ActiveSheet.Rows(8)) = 0
>
> In article <F4CF998C-735E-44A6-984C-(E-Mail Removed)>,
> Bob <(E-Mail Removed)> wrote:
>
> > I would greatly appreciate any help in writing the necessary line(s) of code
> > to determine if a given row (e.g., 8) in the active workbook is completely
> > blank.
> > Thanks,
> > Bob
>

's Computer Specifications

Gary - Thanks!

"Gary Keramidas" wrote:

>
> this should return a zero if the row is blank:
>
> application.counta(rows(8))
> --
>
>
> Gary
>
>
> "Bob" <(E-Mail Removed)> wrote in message
> news:F4CF998C-735E-44A6-984C-(E-Mail Removed)...
> >I would greatly appreciate any help in writing the necessary line(s) of code
> > to determine if a given row (e.g., 8) in the active workbook is completely
> > blank.
> > Thanks,
> > Bob
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
determining if users Password is blank or standard	Martin	Microsoft Access Security	2	8th Aug 2009 03:59 PM
Determining if a user has a non-blank password	=?Utf-8?B?Q2h1Y2sgVw==?=	Microsoft Access Security	2	6th Aug 2009 03:48 AM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........	amorrison2006@googlemail.com	Microsoft Excel Programming	2	7th Jun 2007 09:27 PM
determining whether all cells in a row are blank	rub	Microsoft Excel Programming	2	28th Nov 2006 07:02 PM
Blank Sender, Blank Subject, Blank Body	=?Utf-8?B?c2luMTQ3MA==?=	Microsoft Outlook Discussion	2	4th Nov 2005 01:02 PM