Enter this tiny macro:

Sub gsnu()
Dim v As Variant
v = InputBox("Enter content: ")
For Each r In Selection
r.Value = v
Next
End Sub

First select the cells you want to fill and run the macro.
--
Gary's Student


"Marcel Marien" wrote:

Can anybody tell me how it is possible in Excel (office 2000) to insert by
program a certain content into a selection of single fields from different
colums and rows without altering their format? It would be the equivalent to
manually inserting a copied value into a selection of fields.

Thank you very much in advance,
Marcel