Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to change this code so that the same thing that happens in Sheet 2
will also happen in a 3rd worksheet called Sheet 3. Might you be able to help? Sub ML() Dim rw As Long Dim rngSource As Range Dim rngDest As Range Dim rng As Range Set rngSource = Worksheets("Sheet 1").Range("A4:H200") Set rngDest = Worksheets("Sheet 2").Range("B4") With rngSource Set rngDest = rngDest.Resize(.Rows.Count * 2, .Columns.Count) End With For Each rng In rngSource.Rows rw = rw + 2 rngDest.Rows(rw).Value = rng.Value Next Set rngSource = Worksheets("Sheet 1").Range("Ak4:AK200") rw = -1 For Each rng In rngSource rw = rw + 2 rngDest(rw, 1).Formula = "=" & rng.Address(external:=True) Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel arrows don't move black box but move the window | Excel Discussion (Misc queries) | |||
Find value and move to end of data in same row then move values in | Excel Programming | |||
excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
How do I stop making the spreadsht move when I move up/dwn/lt/rt? | Excel Worksheet Functions | |||
When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) |