input of selected cells equals content of another cell

[al]

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

 

[Mike H]

Try

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

Mike

 

[al]

Try

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

Mike

thxs