Hey Martin,

It did work with my other workbook...only this time with very few cells
selected. I'll see what I can do. Thanks for your help.

Skydiver

"MartinW" wrote:

Hi John,

Try from scratch with a brand new workbook.
Select cell B2 then press and hold 'ctrl' and select C3,D4, E5,F6,A1.
Release 'ctrl' then click in the name box and type in trial and then
'enter'.
Now click in an empty cell off to the side somewhere.
Now click on the name box pulldown arrow and click on trial.
All six cells should be highlighted.
Type a value in A1 and hit 'enter' and it will jump to B2 etc.etc.

Does that explain the process better?

HTH
Martin