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

How reference columns numerically (not Cells() )
 

Columns(2).Resize(,numparts).Select


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


McManCSU wrote :


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