| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill range/series help required please | Excel Discussion (Misc queries) | |||
| Fill Blank cells in a range | Excel Discussion (Misc queries) | |||
| Range Names & Auto Fill | Excel Worksheet Functions | |||
| How to fill a range with data from another range? | Excel Discussion (Misc queries) | |||
| automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Linear Mode
