| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if certain row # is blank
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining if certain row # is blank
this should return a zero if the row is blank: application.counta(rows(8)) -- Gary "Bob" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining if certain row # is blank
One way:
Dim bLine8IsBlank As Boolean bLine8IsBlank = Application.CountA(ActiveSheet.Rows(8)) = 0 In article , Bob 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining if certain row # is blank
JE - Thanks!
"JE McGimpsey" wrote: One way: Dim bLine8IsBlank As Boolean bLine8IsBlank = Application.CountA(ActiveSheet.Rows(8)) = 0 In article , Bob 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining if certain row # is blank
Gary - Thanks!
"Gary Keramidas" wrote: this should return a zero if the row is blank: application.counta(rows(8)) -- Gary "Bob" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| determining whether all cells in a row are blank | Excel Programming | |||
| Need help determining # of invoices | Excel Discussion (Misc queries) | |||
| Determining if Macro Can Run | Excel Programming | |||
| Determining Row Number | Excel Programming | |||
Linear Mode
