trunc function

[montecarlo2012]

Hello, I know if I use trunc function is to avoid decimals, so I am trying to write a code, and I have this line Range("J" & lRow) = Cells(lRow, "I")/ 6 HOW TO AVOID THE DECIMALS in this case. thanks for any help. <o></o>

 

[Rick Rothstein]

Hello, I know if I use trunc function is to avoid decimals, so I am trying to write a code, and I have this line Range("J" & lRow) = Cells(lRow, "I")/ 6 HOW TO AVOID THE DECIMALS in this case. thanks for any help. <o></o>

Will you ever have negative values in those cell in Column I?

 

[montecarlo2012]

So far I have a long decimals, like 12.66666667 and so on, but, you know more, I really appreciate your opinion, you help me so many times, how in Vba is possible to use ABS(TRUNC( , Thank you Mr. Rick Rothstein. All my column are numbers bigger than 6, so no negatives. thank you.

 

[Rick Rothstein]

All my column are numbers bigger than 6, so no negatives.

In that case, you can just use the Int function...

Range("J" & lRow) = Int(Cells(lRow, "I")/ 6)

 

[montecarlo2012]

Mr. Rick Rothstein, thanks, your are great.

 

[montecarlo2012]

Mr. Rick thank you, you are great.