You would need VBA code for that........are you up for that? If so, explain
what values you want put in those cells when you type 41 in your key cell,
and which cell is to be the key cell.......and any other conditions you can
think of........someone will help.....

Vaya con Dios,
Chuck, CABGx3


"Cells" wrote in message
...
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in another
cell cell Named Row_No. The rumber number 41 will keep changing but the
column numbers are the same ie E, H and B please help

Thanks