View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] axwack@gmail.com is offline
external usenet poster
 
Posts: 4
Default Looping through cell

This has to have been addressed before but I'm having some problems
and I was hoping a guru could help me.

I have a column whose row size is variable. In some of the cells for
that column, there is a blank or null value. I want to place NA in
that value and iterate through the cell until the end.

I seem to be able to get the columns row size but I can't seem to
iterate through each cell and check for the null value.

Here is an example of the row:
J
--------
Mod%

..123
..345
..234

..234

..234 [end]