View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Blubber Blubber is offline
external usenet poster
 
Posts: 18
Default Copy Multiple non adjacent columns from one Worksheet to another

Hi guys,
I am trying to create a macro that would Copy Columns A-H,K,M,N,S,U from
worksheet("DrList") to WorkSheet("DrListCal") within the same workbook. I
know how to select ajacent columns but how do we deal with non ajacent ones?

Would appreciate some help codding. Thanks