What I need is to copy and past data only - Skip blanks
This works if i use paste special but cannot make it work using vba see below.
Sheets("Tracker2").Select
Range("D3:h431").Select
Selection.Copy
Sheets("Tracker").Select
Range("C3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Help
This works if i use paste special but cannot make it work using vba see below.
Sheets("Tracker2").Select
Range("D3:h431").Select
Selection.Copy
Sheets("Tracker").Select
Range("C3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Help