Hi,
How can i paste starting from the current cell(that's currently selected)?
I'm using the below code perfectly,but i need to paste the data in the cell
that's currently selected,not to the cell "C4" as indicated below...


Workbooks.Open Filename:= _
"T:\Mourad's Team\Copy of TALISMA\Service Line Reports\Talisma
Report Template.xls"

Range("B9:Z9").Select
Selection.Copy
Windows("Daily report 07.xls").Activate
Range("C4").Select
PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("F17").Select