View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stefantem[_9_] stefantem[_9_] is offline
external usenet poster
 
Posts: 1
Default Problem setting a range


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

--
stefante
-----------------------------------------------------------------------
stefantem's Profile: http://www.excelforum.com/member.php...fo&userid=1359
View this thread: http://www.excelforum.com/showthread.php?threadid=27037