Error 438

[Madhavan]

Hello everybody,

I have just joined my first job, and was surprised to find how extensively excel is applied to the workplace, having only been familiar with the "sum" and other basic arithmetic function uptill now.

Today I was experimenting with macros and the error 438 which states " object does not allow the operation to be performed'.

the piece of code which caused the runtime error is show in quotes and the specific line is highlighted below.

"

Range("R9:Y9").Select
ActiveCell.FormulaR1C1 = "*"
Range("R9:Y11").Select
Selection.FillDown
Range("B18:M19").Select
Range("B19").Activate
Selection.ShapeRange.Item(1).Hyperlink.Follow NewWindow:=False, AddHistory _
:=True
Range("X14:AH14").Select
With Selection

"

I wanted to get some help in understanding what the problem is and if possible solution. If more elaborate description of the problem is reqd please inform.

[dilipandey]

Hi Madhavan,

Microsoft has a tutorial on this error type:-

http://support.microsoft.com/kb/287114

Regards,
DILIPandey

<click on below 'star' if this helps>