| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pasting copied cells
I have a problem excel macro. I want to paste some previously
copied rows into another sheet. Bu not into location "A1" of the sheet, I want it to paste into A10. I made a code as below. Sheets("a").Activate Sheets("a").Rows("A10").Select ActiveSheet.Paste But it dosnt work, it pastes the rows to "A1". Why? Thanks a lot. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting copied cells
Uzytkownik "oercim" napisal w wiadomosci oups.com... I have a problem excel macro. I want to paste some previously copied rows into another sheet. Bu not into location "A1" of the sheet, I want it to paste into A10. I made a code as below. Sheets("a").Activate Sheets("a").Rows("A10").Select ActiveSheet.Paste But it dosnt work, it pastes the rows to "A1". Why? Thanks a lot. try to change Sheets("a").Rows("A10").Select into Sheets("a").Range("A10").Select mcg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting copied cells
No need to activate
Copy example fton sheets b to a Sheets("b").Rows("50:52").Copy Sheets("a").Range("A10") -- Regards Ron de Bruin http://www.rondebruin.nl "oercim" wrote in message oups.com... I have a problem excel macro. I want to paste some previously copied rows into another sheet. Bu not into location "A1" of the sheet, I want it to paste into A10. I made a code as below. Sheets("a").Activate Sheets("a").Rows("A10").Select ActiveSheet.Paste But it dosnt work, it pastes the rows to "A1". Why? Thanks a lot. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting copied cells
A better way might be something like
Sheets("b").Range("A100").Copy Sheets("a").Range("A1") copies cell a100 from sheet b to cell a1 in sheet a... -- HTH... Jim Thomlinson "oercim" wrote: I have a problem excel macro. I want to paste some previously copied rows into another sheet. Bu not into location "A1" of the sheet, I want it to paste into A10. I made a code as below. Sheets("a").Activate Sheets("a").Rows("A10").Select ActiveSheet.Paste But it dosnt work, it pastes the rows to "A1". Why? Thanks a lot. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting content copied from nonadajacent cells | Excel Discussion (Misc queries) | |||
| Pasting copied AutoFiltered cells in Excel2007 | Excel Discussion (Misc queries) | |||
| Excel 2002: Problem in pasting copied data to Coda Financial | Excel Discussion (Misc queries) | |||
| Excel 2002: Problem in pasting copied data to Coda Financial Acco | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
