Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, i have this code:
Sub copy1() Dim lastRow As Long lastRow = Worksheets("Sheet2").Cells(Worksheets("Sheet2").Ro ws.Count, "A").End(xlUp).Row Worksheets("Sheet1").UsedRange.Copy Worksheets("Sheet2").Activate Range("A" & (lastRow + 1)).Select ActiveSheet.Paste End Sub Can this code be made to copy rows to a specific sheet? In "M1" i will write october, so when i run macro, the code to copy rows to "october" sheet. If i write november, then the code to copy rows to "november" sheet. Can this be done? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
2Q:Indirect worksheet selection in macro, Calc off for specific sh | Excel Discussion (Misc queries) | |||
Using INDIRECT in a macro/vba | Excel Discussion (Misc queries) | |||
Macro that sort on clnm populated by indirect | Excel Discussion (Misc queries) | |||
Using Indirect & Creating a worksheet Macro | Excel Worksheet Functions |