| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Usinf function in macro
I want to write a macro using Excel function in it e.g. Average. Using the record macro, I get the code "=Average(RC[1]:R[0]C[12])" However, I want that the range is input by the user i.e the no. of column is unknown. So how do I change the code? -- hurriance ------------------------------------------------------------------------ hurriance's Profile: http://www.excelforum.com/member.php...o&userid=30882 View this thread: http://www.excelforum.com/showthread...hreadid=511502 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not sure what function, macro, etc to use | Excel Worksheet Functions | |||
| Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
| Changing text color usinf a formula (NOT Conditional Formatting) | Excel Discussion (Misc queries) | |||
| Usinf cells for filename | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Threaded Mode
