JamieDuncan
Board Regular
- Joined
- Aug 23, 2006
- Messages
- 132
I am trying to reproduce formulae over a couple thousand rows, unfortunately there are gaps but the formulae must remain sequential,
this is the basic recorded macro to cut copy the data as it is needed but i would like a macro that can start from any active cell (being the top left cell of the first range) as i have to repeat this procedure over several sheets (first sheet took 4 hours!)
Tried using integers but got myself in a kerfuffle!
Help me!
this is the basic recorded macro to cut copy the data as it is needed but i would like a macro that can start from any active cell (being the top left cell of the first range) as i have to repeat this procedure over several sheets (first sheet took 4 hours!)
Tried using integers but got myself in a kerfuffle!
Help me!
Code:
Sub Macro1()
Range("A13:M29").Select
Application.CutCopyMode = False
Selection.Copy
Range("O21").Select
Application.CutCopyMode = False
Range("O21:AA37").Cut Destination:=Range("O50:AA66")
Range("O50:AA66").Select
Selection.Copy
Range("A50").Select
ActiveSheet.Paste
End Sub