Hi Roger Govier and Bryan Hessey
Thank you both for your reply
regards Bill
--
bill gras


"Roger Govier" wrote:

Hi Bill

You could turn on the macro recorder as you do it.
ToolsMacroRecord new Macro and it the shortcut key box enter the
combination of keys you would like to invoke the macro with.
Carry out the steps Bryan advised and at the end press the Stop button.
Now a Simple key combination will do the task for you.

Regards

Roger Govier



bill gras wrote:

Hi Bryan
Thank you for your input
Is there a way of using a worksheet function , I have to do
this about 10 times per day
regards bill