how to write a VBA function ?

G

Gord Dibben

mansure

I would suggest trooping off the David McRitchie's "getting started with
macros" site and read a while then practice.

Make use of the Macro Recorder under Tools<Macro>Record New Macro.

The code produced will do the trick in most cases. It is not the most elegant
code and you will learn how to refine it by watching these news groups,
especially the excel.programming group.

Tushar Mehta has a site that is useful also.

http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm

Shows how to use the recoder and make refinements.

Gord Dibben Excel MVP
 
Top