Thread: Error retrieving value of the specified Excel cell (Not active)
View Single Post
  #1   Report Post  
Posted to microsoft.public.vb.general.discussion,microsoft.public.excel.programming
jack jack is offline
external usenet poster
  
Posts: 97
Default Error retrieving value of the specified Excel cell (Not active)
I am trying to retieve content of specified (row, column) cell.

Set oExcel = GetObject(, "Excel.Application") ' get existing Excel Object

oExcel.Cells(11, 17).Value

The above code works fine in Immediate window but in run time creates error:
'438': Object doesn't support this property or method"

How to retrieve value of the specified cell (Not active) ?


Reply With QuoteReply With Quote