input of selected cells equals content of another cell
 

Looking for a macro which would input the contents of cell N8 in my
range of selected cells
Pls help

input of selected cells equals content of another cell
 

Try

Set rng = Selection
rng.Value = Range("N8").Value

Mike

"al" wrote:

Looking for a macro which would input the contents of cell N8 in my
range of selected cells
Pls help

input of selected cells equals content of another cell
 

On Jan 20, 4:23 pm, Mike H wrote:
Try

Set rng = Selection
rng.Value = Range("N8").Value

Mike

"al" wrote:
Looking for a macro which would input the contents of cell N8 in my
range of selected cells
Pls help

thxs