View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Louie Louie is offline
external usenet poster
 
Posts: 40
Default copy values from range of columns

hello. i need some help. how do i copy values from range of columns ex. AA:AI
of sheet1 to D3:K3 of sheet2 with an interval of 6? i used the for loop, ex.
for x = 1 to y step 6 but it didnt work.