View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Error: Wrong number of argument or invalid property assignment?

You probably have created a function or sub and named it Range. You need to
delete this function or sub.

--
Regards,
Tom Ogilvy


"Mike" wrote:

Hi everyone,

I am getting the above error at the 1st line?

Sub TTT()
'
' TTT Macro
' Macro recorded 7/11/2006 by sultanm
'

'
Range("B11").Select
Selection.Copy
Range("E18").Select
ActiveSheet.Paste
Range("E18").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "4.22222222222222"
Range("E19").Select
End Sub

Mike