Why not just select an area noRows x noCols, enter a 1 in the formula bar,
and then hit Ctrl-Enter?


HTH

Bob

"xtriant" wrote in message
...

Hello,

I would like to create a function, such that if I type

"=testfunction(noRows, noCols)"

into a cell in Excel, say A1, then the range beginning from A1 until
cell(noRows, noCols) is filled with "1". Of course, this isn't
possible with UDFs in VBA, but I have seen it before with some special
programs which can be added/installed into Excel and provide such a
functionality. I was thinking about implementing a C#/.NET method that
way, save it in some file, and everyone who wants to use this function
would then just need to install/reference(?) this file that I would
provide him.

Any ideas/suggestions/links/keywoards which I can look up?

Thanks a lot in advance!