Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with code location PL EASE
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with code location PL EASE
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/ "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with code location PL EASE
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 "PCOR" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Code for a button to change cell location | Excel Discussion (Misc queries) | |||
Ease of entry on an form designed in excel | Excel Discussion (Misc queries) | |||
Financial projections calendar in a Outlook-style for ease of use | Excel Discussion (Misc queries) | |||
File Location code | Excel Programming |