how to access column 8 in my Range

  • Thread starter Thread starter rpsmith
  • Start date Start date
R

rpsmith

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to access column 8 in my Range 2
insert a line 1
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Return latest date in range? 11
Two Totals from the same column 2
Excel VBA 1
New to SUMPRODUCT .. is there a better way? 1
MACRO RUN random percentage and copy of column values 1

Back
Top