View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Multiply a Range by a Constant

I would like to multiply a range by a constant. My range is Target

Target.value = [Target.value] * sngPercent

is what I have but it doesn't work. Any suggestions besides traversing the
range one element at a time?

Thanks In Advance...