| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why it is not pasting it to the correct place?
Hi,
I have a simple code to paste some data which is in "Sheet1" to "Sheet2". ========== Sub test1() Worksheets("Sheet1").Range("data").Copy Worksheets("Sheet2").Paste Destination:=Range("a20") End Sub ======= Although I am clearly defining that it should paste on "Sheet2" it nevertheless pastes on "Sheet1". Any explanation why it does not paste on "Sheet2"? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fig from excel not correct decimal place when merged. In word | Excel Discussion (Misc queries) | |||
| can excel auto correct when cutting and pasting | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
| 1st, 2nd, 3rd Place etc..... | Excel Worksheet Functions | |||
Threaded Mode
