small helpp in coding

[naikadit]

I am new bie and I am getting error in ths step just a small thing can you guys please help me out

Set objSheet = objExcel.ActiveWorkbook.Worksheets("RBS Site")
dim i,k ,j, isFloat, toTest, xlup, nmaxrow
xlup=&HFFFFEFBE
nmaxrow=objSheet.range("a65536").end(xlup).row -- to go till end of the row
objExcel.ActiveWorkbook.Worksheets("RBS Site").Range("A1:T(nmaxrow)").Value = objExcel.ActiveWorkbook.Worksheets("RBS Site").Range("A1:T(nmaxrow)").Value ---getting error here

 

[PHV]

getting error here
Which error ?

Anyway, what about this ?
objSheet.Range("A1:T" & nmaxrow).Value = objSheet.Range("A1:T" & nmaxrow).Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886