Need help with code location PL EASE

[PCOR]

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).Range("a1:a200"))

 

[R.VENKATARAMAN]

try this statement

range("a201")=totval
====================

 

[Steve]

1) Alt/F11 brings up the Visual Basic window
2) Insert, Module creates a new module

However, you'll need more to work with than the above. Try the tutorials
here
http://www.geocities.com/WallStreet/9245/

 

[Guest]

TIP

Record a macro. when done, look under tools macros for your macro and select
EDIT...this will take you to the module.
The module is a standard code module...as already mentioned by otheres, but
this way you'll get to see where it sits if you look in the Project Window of
the IDE.

Patrick Molloy
Microsoft Excel MVP