Excel Function.

[Amit Singh Chauhan]

Hi,

I have an excel sheet and have to Copy a range of cells and paste them to anaother sheet which is in other workbook.

I have functions to do this job.

But these function throws general run error after sometime and when I click on Retry button start functioning properly.

I have used following code.

Code:

Set objExcel = GetObject(,"Excel.Application")
Window("Excel").Activate

objExcel.ActiveWorkbook.ActiveWorksheet.Range("A1","F1").Select

Above line throws error sometimes and works properly at some other time.

Is there any other way to to this task???