View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default CopyIntoFirstEmptyRowHorizontally

I hope someone can help
I need to write a macro to do the following
I have worksheet A, which I want to copy the values of Cells B1:B2
The macro will search worksheet B for the first empty row starting with row A2
Then copy worksheet A, cells b1:b20 into worksheet B HORIZONTALLY in cells A2:T

thank
Mike