View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SMS - John Howard SMS - John Howard is offline
external usenet poster
 
Posts: 16
Default Excel, Hash (#) in VBA Calculations

Hi Folks,

I have recently inherited care of an Excel XP model that contains the
following calculations, containing the # symbol.

Amount = Amount / 100#
NewValue = OldValue * -1#

I can see where the variables Amount, NewValue and Old Value are declared
but nothing on the #.

The end results sor t of make sense if the # symbols were in fact the %
sign. Other than that I am totally confused.

Does this use of the # symbol make sense to anyone.

TIA

John Howard
Sydney, Australia