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.

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" <(E-Mail Removed)> wrote in message
news:0afa1d81-9ce1-4bb4-95ce-(E-Mail Removed)...
> 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.
>
>