new to excel vba RRS feed

  • Question

  • Hi, 

    if I want to copy paste a some raw and column from sheet1 to sheet2 till the column is fill with text??

    Saturday, March 16, 2013 1:22 PM

All replies

  • no problem - you can use .Copy commend:

    Workbooks(ActiveWorkbook.name).Sheets("Sheet1").Rows(1).Copy Sheets("Sheet2").Rows(1)

    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Saturday, March 16, 2013 3:45 PM
  • Hi,

    Thank for the solution it really helped me but if I want to copy the row till the end of the data then how do I go for it ???

    Please help and teach me



    Sunday, March 17, 2013 3:22 PM