Hello I have recently started making spreadsheet for companies and need some help with a macro.

I need to know the code that will make the Marco paste over a selected area e.g. K1:AH63 but will not override cells with information already entered in them. For example the paste area is A1:C3 and A2 contains data, when the Marco pastes over this area it will paste the copied data in cells A1, A3, B1, B2, B3, C1, C2 and C3 but leaves a2 untouched.

thanks for all the help, Pete

Here is the code so far:

Sub SynPage()
'
' SynPage Macro
' Macro recorded 28/04/2005 by Peter Sutton
'

'
Range("K1:AH63").Select
Selection.Copy
Sheets("Purchase Codes Overview").Select
Range("D3").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=True, Transpose:=False
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=True, Transpose:=False
Application.CutCopyMode = False
Range("A1").Select
Sheets("Drop Sheet").Select
Range("G3").Select
End Sub