Recognizing a whole number instead of a decimal
 

Please help. What VBA code could automate the recognition of a whole number
instead of a decimal? My pending programming will generate values that are
either whole numbers or decimals. I only want to recognize whole numbers.

Thank you very much.

Recognizing a whole number instead of a decimal
 

Hi

A general test
if n = INT(n) then

Best wishes Harald

"horsepro001" skrev i melding
...
Please help. What VBA code could automate the recognition of a whole
number
instead of a decimal? My pending programming will generate values that are
either whole numbers or decimals. I only want to recognize whole numbers.

Thank you very much.

Recognizing a whole number instead of a decimal
 

Assuming the number is in variable myNum

If myNum = Int(myNum) Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"horsepro001" wrote in message
...
Please help. What VBA code could automate the recognition of a whole
number
instead of a decimal? My pending programming will generate values that are
either whole numbers or decimals. I only want to recognize whole numbers.

Thank you very much.

Recognizing a whole number instead of a decimal
 

Thank you!!!

"Harald Staff" wrote:

Hi

A general test
if n = INT(n) then

Best wishes Harald

"horsepro001" skrev i melding
...
Please help. What VBA code could automate the recognition of a whole
number
instead of a decimal? My pending programming will generate values that are
either whole numbers or decimals. I only want to recognize whole numbers.

Thank you very much.

Recognizing a whole number instead of a decimal
 

Thank you!!!

"Bob Phillips" wrote:

Assuming the number is in variable myNum

If myNum = Int(myNum) Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"horsepro001" wrote in message
...
Please help. What VBA code could automate the recognition of a whole
number
instead of a decimal? My pending programming will generate values that are
either whole numbers or decimals. I only want to recognize whole numbers.

Thank you very much.