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
|