Thread: empty cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
רוזנט רוזנט is offline
external usenet poster
 
Posts: 29
Default empty cell

one way to chek if is empty cell in column is
by dividinge the count cells in the rows in the column

i tried to build a code like this:

if counta(XXX)/rows(XXX)<1 then
do .....
else
.......
it didn't work
i ask you to help me only by this way
i think this code is wrong becuse of the dividing sign

thank you
rozent