Dragging a macro like a formula

[aramacha]

I was wondering if there was a way to write a macro that is essentially a formula and can be treated as such. What i mean is that if i run the macro in one row and then select that row and drag it down, it should update automatically. is there a way. also, what sort of notation will be used. will it be RC[1] notation. thanks. anish

[Paul]

You can use VBA to create formulas, which would allow you to drag-fill them to other cells - they're called User Defined Functions.

They are very similar to macros, except they have some limitations. Here are a few examples of UDF creation and info:

http://www.vertex42.com/ExcelArticle...functions.html

http://www.ozgrid.com/VBA/Functions.htm

http://www.exceltip.com/st/Writing_Y...Excel/631.html