input of selected cells equals content of another cell

al · Jan 20, 2009

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

Mike H · Jan 20, 2009

Try

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

Mike

al · Jan 20, 2009

Try

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

Mike

thxs