Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Value
I'm trying to change the value of a range of cell
eg: would like cell range d2:d9 to be filled with 1's |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Value
weasel, here is one way, Range("D2:D9") = "1"
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003 ** remove news from my email address to reply by email ** "Weasel" wrote in message ... I'm trying to change the value of a range of cell eg: would like cell range d2:d9 to be filled with 1's |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Value
From a macro
Range("D2:D9").Value - 1 From the worksheet, select D2:D9, type 1 in D2, then press CTRL+ENTER. On Fri, 3 Sep 2004 17:51:01 -0700, Weasel wrote: I'm trying to change the value of a range of cell eg: would like cell range d2:d9 to be filled with 1's |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Value
one way:
Range("D2:D9").Value = 1 In article , Weasel wrote: I'm trying to change the value of a range of cell eg: would like cell range d2:d9 to be filled with 1's |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
changing a cell to changing the link | Excel Worksheet Functions |