View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Method selection of object _Global falied

I don't speak VB, but how about:

with oExcel.selection

But even better, why not:
with .range(oWorkSheet.Cells(i, 1), oWorkSheet.Cells(i,MyRange))

And drop the selection completely.

Leon wrote:

I'm working at VB code
With oWorkSheet
.Range(oWorkSheet.Cells(i, 1), oWorkSheet.Cells(i,MyRange)).Select
With Selection <-- and in this place I obtain error

Method selection of object _Global falied

I declare objects such as oExcel, oWorkBook, oWorkSheet as Object
and then i set'em to appropriate Excel objects.

That kind of behavior I get only in W2K + A2K + E97 enviroment
In WXP + A2K + E2K everything goes ok! :|

Can anyone help me ;)

Thanx in advice, Leon!


--

Dave Peterson