View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 110
Default Need help with code location PL EASE

try this statement

range("a201")=totval
====================
PCOR wrote in message
...
Hi
I have been reading many tutorials but am still lost when it come to where
to place code.
I see the code below will total all the number in col A from line 1 to
200.Great...but where do I put this code and how to I call it
Please be very specific..Thanks
totVal = Application.WorksheetFunction.Sum(Worksheets(1).Ra nge("a1:a200"))
--
Norton Professional 2004 says this email is clean...believe it