View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
 
Posts: 783
Default What does "\" do in VBA

Chip Pearson wrote:
It means integer divide. It disregards any fractional part of the
result. E.g.,

8 \ 3 = 2


Before division is performed, the numeric expressions are rounded to
Byte, Integer, or Long expressions. E.g.,

8 \ 2.5 -------- 4 (it rounds the 2.5 to 2)
8 \ 2.6 -------- 3 (it rounds the 2.6 to 3)

Alan Beban