View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
McManCSU[_7_] McManCSU[_7_] is offline
external usenet poster
 
Posts: 1
Default How reference columns numerically (not Cells() )


Is there a way to select columns on a numeric (vs alpha) notation? My
amount of columns is always changing so I want to reference them by
numbers. How can i do this and still get the WHOLE column?

This doesnt work...

Columns("2:numparts+2").Select

Thanks


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=380629