Fill Range With A Value
 

What code would I use to fill a all the cells in a selected range with the
same value. The user will highlight a range, and I want to simulate as if an
item were pasted in, except it will be in code. How do I fill every cell
with this one item:

myKey = "Test"
Selection.Range.Value = myKey

Fill Range With A Value
 

try:
Selection.Value = myKey


"Derek Hart" wrote:

What code would I use to fill a all the cells in a selected range with the
same value. The user will highlight a range, and I want to simulate as if an
item were pasted in, except it will be in code. How do I fill every cell
with this one item:

myKey = "Test"
Selection.Range.Value = myKey