Excel: Making sure there is numeric data in one column 1

[mmtraining]

In a table people fill in information about costs. If they are not sure, they either leave the cell free or write some text or put in a question mark.

I want to find out if the cell next door contains information. If yes, check this cell to see if the contents is numeric and larger than 0, if not larger than zero or if not numeric, then put in a zero. If the cell next door is empty then stop running. Otherwise loop.

My question: How can I check the cell next door (to the left) to see if it contains data? I know I use isempty, but how do I address the cell? I am a bit weak on RANGE and CELLS, sorry.

Thanx for any ideas

Carol
Berlin, Germany

 

[xlbo]

Use
Cell_Ref.offset(0,-1).value

to access the cell to the left so, if you were checking B10, you would use

If Range("B10&quot.offset(0,-1).text = "" then
'A10 is empty
else
'A10 has data
end if

HTH Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes

 

[mmtraining]

xlbo, thanx a lot, not only for this answer but also for the other one.

It is very helpful to have you and the others.

Carol
Berlin, Germany