check for numeric values in a column

E

eighthman11

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.
 
B

Bernard Liengme

Have you tried =COUNT(J:J) ?
It counts how many cells have a numeric value
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop Through Text and Test for Scenarios Q 31
Cumulative formula for word table 0
Setting column width in a table with a macro is not working 0
passing a non numeric cell for numeric comparison 2
Check for values in column A and if found then column B must have value. 3
Use a variable in a ShapeRange.Increment 0
Found few bugs in my daily routine of work in excel for MAC 0
Find string from column A in Range("B2:F7") list the header of that column/s 5

Top