Macro Copy Cells
Posted by Andonny on January 25, 2001 3:25 PM
I am hoping to find a kind person who would modify the code below for me.
It copies the cells between "Area 2 Start" and "Area 2 Finish" from sheet1 to sheet2.
What I would like to change is that it copies only the cells up to Culumn F.
At the moment it copies all culumns across. I have cells with data on sheet2 after culumn F which I don't want to disturb.
Thank you very much
Dim Area2St As String, Area2Fn As String
Area2St = "A" & .Find _
(What:="Area 2 Start", After:=.Cells(1, 1)).Row
Area2Fn = "D" & .Find _
(What:="Area 2 Finish", After:=.Cells(1, 1)).Row
.Range(Area2St & ":" & Area2Fn).Copy _