Hi Bill

yes, you are correct - badly worded on my part .. .a VBA function can not
make changes to another cell whereas a sub procedure (macro) can

--
Cheers
JulieD
"Bill Martin -- (Remove NOSPAM from address)"
wrote in message ...
JulieD wrote:

... if it's a vba function then you can using code along the lines of

Cell(3,3).value = 1


Am I correct though that you can only do that if you're using VBA to write
a macro as opposed to a function? A VBA function can only return a single
value and not alter spread sheet cells? While a macro can reach out and
touch anything?

I'm still trying to feel my way through some of this.

Bill