Yes,how do I specify which cell to be taken care of ?

"Jim Thomlinson" wrote in message
...
In a manner of speaking yes you can apply a macro to a cell. You can use
the
Change event to make a macro run each time the cell is changed. To access
the
change event Right Click on the Sheet tab in Excel - Choose View Code
(just
above the left hand side of the code window you will see a drop down list
with the word general in it. Change it to worksheet. When you do this a
procedure will be added to the code window which is the Selection Change
event (you can delete this as you don't need it). To the right of the box
you
just changed there is a drop down list. Select Change from that list. This
procedure will fire when any cell is changed. If you have some specific
cells
in mind let me know and I can help you narrow down the cells...
--
HTH...

Jim Thomlinson


"John McMicheal" wrote:

I would like to assign a macro to a cell so that when that cell is
populated
the series of formattting is applied to other cells. Can I apply a macro
to
a cell?