Yes, it's possible. Turn on the macro recorder (Tools | Macro Record new
macro...), do whatever it is you want by hand, and turn off the recorder.
In most cases, XL will give you the necessary code that you can then adapt
and customize further.
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I am trying to create a macro to create Comments in Cells from text in
adjacent cells. Is this possible?


--
psmall
------------------------------------------------------------------------
psmall's Profile: http://www.excelforum.com/member.php...o&userid=27647
View this thread: http://www.excelforum.com/showthread...hreadid=508147