Thread: How reference columns numerically (not Cells() )
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
  
Posts: 2,253
Default 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
Reply With QuoteReply With Quote