| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to access column 8 in my Range
Hi,
I want to place "1" in column 8 in every row in my range named "LegendList". How do I do this? I tried: LegendList(, 8) = "1" and I tried With LegendList .Cells(, 8) = "1" end with Neither works... Help...please Thanks, Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to access column 8 in my Range
Hi Paul, Try: Range("LegendList").Columns(8).Value = 1 --- Regards. Norman "rpsmith123" wrote in message ... Hi, I want to place "1" in column 8 in every row in my range named "LegendList". How do I do this? I tried: LegendList(, 8) = "1" and I tried With LegendList .Cells(, 8) = "1" end with Neither works... Help...please Thanks, Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to access column 8 in my Range
On May 21, 12:35*pm, rpsmith123 wrote:
Hi, I want to place "1" in column 8 in every row in my range named "LegendList". How do I do this? I tried: LegendList(, 8) = "1" and I tried With LegendList * *.Cells(, 8) = "1" end with Neither works... Help...please Thanks, Paul If LegendList is a named range in your workbook, which I'm assuming it is, you need to reference it using Range. Something like this. Range("legendlist").Cells(, 8) = "1" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| strange range access | Excel Programming | |||
| How do I Export range of row/column data to Access | Excel Discussion (Misc queries) | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
| How do I access each cell in a range | Excel Programming | |||
| Transfering VBA Array Column Range to Excel Column Range | Excel Programming | |||
Linear Mode
