| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: Wrong number of argument or invalid property assignment?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compile Error: Wrong arguments or Invalid property | Excel Discussion (Misc queries) | |||
| Wrong number of arguments or invalid property assignment | Excel Programming | |||
| Wrong Number of Arguments or Invalid Property Assignment??? | Excel Programming | |||
| Compile Error - Wrong number of arguements or invalid property ass | Excel Programming | |||
| Wrong number of Arguments or Invalid property assignment | Excel Programming | |||
Linear Mode
