View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] menken.john@gmail.com is offline
external usenet poster
 
Posts: 14
Default Copying many columns into one column

Thanks Claus,
It threw an error with this line of code:


..Range("A:A").Sort key1:=.Range("A1"), order1:=xlAscending,
Header:=xlNo