Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluating a range
I would appreciate some help on evaluating a range
(Columns A:K). The problem is that there are several different variable types within this range. How can I code the program to say if all cells are blank, do "X". I could look at each cell in each column for each row but that doesn't seem to be efficient. Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluating a range
Mike,
Try something like the following: If Application.WorksheetFunction.CountA(Range("A:K")) = 0 Then Debug.Print "All Blank" Else Debug.Print "Not all blank" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mike" wrote in message ... I would appreciate some help on evaluating a range (Columns A:K). The problem is that there are several different variable types within this range. How can I code the program to say if all cells are blank, do "X". I could look at each cell in each column for each row but that doesn't seem to be efficient. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Evaluating formula in VBA | New Users to Excel | |||
#Value! error when evaluating data in a cell range | Excel Worksheet Functions | |||
Evaluating division by zero | Excel Worksheet Functions | |||
Function not evaluating | Excel Discussion (Misc queries) | |||
Evaluating a range | Excel Discussion (Misc queries) |