difficult question
I want to write a marco that to copy few specified rows from sheet 1 to sheet
2:
.................................................. .................................................. ....
R=Inputbox("pls input the first row number")
R1=inputbox("pls input the last row number")
Rows(R:R1).Select
Selection.Copy
Sheets("Sheet2").Select
ActiveSheet.Paste
.................................................. .................................................. ......
But, the above macro is not work at "Rows(R:R1).Select", I would like to use
inputbox to enter specified number of row to copy from sheet1 to sheet2. How
to do that???
|