Problem setting a range

  • Thread starter Thread starter stefantem
  • Start date Start date
S

stefantem

set col = Sheet2.Range("A1:Z1")
for each c in col.Cells
...
set arie
Sheet2.Range(Cells(1,c.Offset(0,0).Column()),Cells(100,c.Offset(0,0).Column()))
(doesn't work)
...
nex
 
Set col = Sheet2.Range("A1:Z1")
For Each c In col.Cells

Set arie = _
Sheet2.Range(Sheet2.Cells(1, c.Column), Sheet2.Cells(100, c.Column))
 
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

Conflict 8
Array with many cells from a row but not in order or together 11
Copy row info but not in normal column sequence 6
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Sheet to sheet code Type Mismatch 6
Resize a row but copy but skip columns I don't want to copy 6
A simple if <> nn then Msgbox "No Match" 5
Select Case Code does not run... 10

Back
Top