| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a test to see if an entire row or column is empty?
If so, can some one show the code?
-- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a test to see if an entire row or column is empty?
Worksheet function -
=COUNTA(A:A)=0 Code - ? application.WorksheetFunction.CountA(sheets("sheet 1").range("A:A")) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Henry Stock" wrote in message ... If so, can some one show the code? -- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a test to see if an entire row or column is empty?
Hi Henry
Try this for the activecell row If Application.CountA(Rows(ActiveCell.Row)) = 0 Then _ MsgBox "Row " & ActiveCell.Row & " Is empty" -- Regards Ron de Bruin http://www.rondebruin.nl "Henry Stock" wrote in message ... If so, can some one show the code? -- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a test to see if an entire row or column is empty?
COUNTA(A:A) will return 0 is column A is empty
COUNTA(10:10) will return 0 is row 10 is empty best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Henry Stock" wrote in message ... If so, can some one show the code? -- Henry Stock, Network Administrator onProject.com 3 Wing Drive Cedar Knolls, NJ 07927-1006 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to SUM entire column, but only when adjacent cell is not empty | Excel Worksheet Functions | |||
| How can I test if a cell is empty? | Excel Discussion (Misc queries) | |||
| Test if the range is empty | Excel Discussion (Misc queries) | |||
| Test if Clipboard is empty | Excel Programming | |||
| Better way to test for empty Recordset | Excel Programming | |||
Linear Mode
