Hi Friend,
As far as I know, we can't change the value of other cells using a
function. This applies to both Built-in and User-defined functions.
Since a sub-routine is a collection of tasks to be performed, much
powerful compared to a function which can change the content of a cell
only from it
Rodney,
Thanks for the help, but I'd like to be able to call this subroutine
from a cell. Is that possible? For instance have cell B2 be =ChangeCell
(A1:A5).
LookingForExceHelp
On Mar 28, 6:27 pm, rspowell wrote:
> Hello Friend --
>
> You need a subroutine to change the range ...
>
> Sub Chang
Hello Friend --
You need a subroutine to change the range ...
Sub ChangeCells(theRange As Range)
theRange.Cells(1,1) = "Hello World"
End Sub
... this will work fine
Hope it helps you !
- Rodney POWELL
[ Microsoft MVP - Excel, 1997-2009 ]
www.BeyondTechnology.com
On Mar 28, 1
