how to access column 8 in my Range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rpsmith - 21 May 2008 17:47 GMT

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

Reply to this Message

Don Guillett - 21 May 2008 18:51 GMT

try this to put the number 1 in each cell

Sub oneinrange()
Range("legendlist") = 1
End Sub

or 8 columns over
Sub oneinrange()
Range("legendlist").Offset(, 8) = 1
End Sub

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 15 lines]
> Thanks,
> Paul

Reply to this Message