| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data moving 2
Hi
Thank's Rick, your discussion is right. regards "Rick Rothstein" wrote: It would have helped if along with telling us what the error message was if you also told us what line it occurred on (which line did the debugger highlight). I have no idea if the following is the root of your problem or not, but this line is not doing what you think... Range("A2:BK2" & x).Copy That is not how you construct the range you want. The "2" at the end of "BK2" should not be there. For example, if "x" evaluates to, say, 999, then your range becomes A2:BK2999, not A2:BK999... that is some 2000 rows below the last piece of data in Column X. I believe you want this instead... Range("A2:BK" & x).Copy -- Rick (MVP - Excel) "climate" wrote in message ... I have following code: Sub climate() Dim x As Long, y As Long x = Range("X" & Rows.Count).End(xlUp).Row y = InputBox("enter the row number to paste") Range("A2:BK2" & x).Copy Range("A" & y).PasteSpecial MsgBox "Updated" End Sub I want to cut data of range(A2:BK2 to end row related) and then paste to row number which determine in Box. when i run above code on some of sheets, error message appear(Run Time error 1004). please note that, this code with cut command not run, only with copy command. any help will be greatly appreciated. climate . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
| Moving data from one worksheet to another whilst removing the data | Excel Discussion (Misc queries) | |||
| moving data to non autofarmatted book changes data- Why? | Excel Discussion (Misc queries) | |||
| moving data in excel without deleting existing data | Excel Discussion (Misc queries) | |||
Hybrid Mode
