View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Runtime error 438

Greetings Greg

It's due to a typo.

Change the line to:

Selection.Value = x+1

Regards,
Per

On 24 Dec., 14:34, Greg Snidow
wrote:
Greetings. *I came across a site that helps introduce the concept of macros. *
There is one example...

Sub Example2()
* * For x = 1 To 5
* * * *Cells(x, 3).Select
* * * *Selection.Vaue = x + 1
* * Next x
End Sub

that is simple enough, but when I try to run it, I get 'Runtime error '438'
Object doesn't support this property or method'. *When I hit help, it says
some stuff about a friend procedure being called late bound, and automation
objects. *Does anyone know what is happening? *Thank you.

Greg