View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek Hart Derek Hart is offline
external usenet poster
 
Posts: 26
Default 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