Simply Remove the "PRIVATE"
Then the code shows up in your list of macros
Is that what you needed?
Further, is the Range you are referring to allways exactly that size
Or can it grow or shrink?
If you create a Macro, you normally want to ba able to cope with range
that change in size.
If the Range that you are working with is a continious block of cells
you might want to try the .currentregion property
Which references all cells that make out the block in which you fin
the specified range.
set MyRng = me.range("o5").currentregio
--
Message posted from
http://www.ExcelForum.com