check for numeric values in a column
 

Hello everyone,

Quick question. I need to check if there are any numeric values in
column "J" if not I allow a refresh of data. Is it possible to sum
column "J" and place the results in a variable using VB code or is
there an easier way to detect if there are numeric values in column
"J". Any help appreciated. Thanks Ray.

check for numeric values in a column
 

Have you tried =COUNT(J:J) ?
It counts how many cells have a numeric value
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"eighthman11" wrote in message
...
Hello everyone,

Quick question. I need to check if there are any numeric values in
column "J" if not I allow a refresh of data. Is it possible to sum
column "J" and place the results in a variable using VB code or is
there an easier way to detect if there are numeric values in column
"J". Any help appreciated. Thanks Ray.