HELP about macro copy and paste
Solved/Closed
marvs
-
Apr 4, 2011 at 02:03 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- HELP about macro copy and paste
- Macro to copy and paste to end of data - Guide
- Excel macro to copy and paste from one worksheet to another - Guide
- Macro to Copy and Paste ✓ - Forum - Excel
- Macro to copy and paste values ✓ - Forum - Excel
- Macro help...copying and pasteing ✓ - Forum - Excel
2 replies
venkat1926
Apr 20, 2011 at 11:33 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Apr 20, 2011 at 11:33 PM
yes for current region you can use a range
something like this
the dot before "range" is important.
it will copy only from A1 to E10. modify to suit you
something like this
With Worksheets("sheet1") .range("A1:e10").copy
the dot before "range" is important.
it will copy only from A1 to E10. modify to suit you
venkat1926
Apr 9, 2011 at 07:18 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Apr 9, 2011 at 07:18 AM
not clear.
you want to copy the two column in sheet 1 to sheet2
if the old data is removed and new data entered you want the new data is to be copied to sheet2 below the data already copied . if this is so
try this macro
you want to copy the two column in sheet 1 to sheet2
if the old data is removed and new data entered you want the new data is to be copied to sheet2 below the data already copied . if this is so
try this macro
Sub test() With Worksheets("sheet1") .Range("A1").CurrentRegion.Copy With Worksheets("sheet2") .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial End With End With Application.CutCopyMode = False End Sub