Fill Range With A Value

  • Thread starter Thread starter Derek Hart
  • Start date Start date
D

Derek Hart

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
 
Back
Top