VBA - "Wrong number of arguments or invalid property assignment" - Cells()

Question

Following a tutorial for arrays on VBA Excel. As you can see, just about everything is commented out and I still get this error. If I use Range("A1", "A1").Value = 1 there's no problem. I also noticed that the intelisense doesn't pick up 'Cells('

Option Explicit

Sub ArrayTest()

'Dim arrayint(1 To 5) As Integer
'Dim i As Integer
'Dim j As Integer


'    For j = 1 To UBound(arrayint)
'        arrayint(j) = 10 * j
'    Next j

'    For i = i To UBound(arrayint)
        Cells(1, 1).Value = 1 'arrayint(i)
'    Next i

End Sub

What version of Excel are you using? Where did you put this code (sheet, workbook, module, ...)? — Michael Liu
– Michael Liu, Commented Apr 6, 2014 at 3:47
Excel 2013. I tried it in sheet, workbook and module. I also tried it in a new excel and still nothing... — Soran
– Soran, Commented Apr 6, 2014 at 4:13
Try using Application then check if Intellisense pick up Cells property. So, in short, try this Application.Cells(1, 1).Value = 1. I have no way to test it at XL 2013, so give it a try. — L42
– L42, Commented Apr 6, 2014 at 4:40
@L42: Thanks !!! It all works now :D Is there a way to not have to use 'Application.' ? Update your answer and I'll mark it the best. — Soran
– Soran, Commented Apr 6, 2014 at 4:59
Well, basically it should work without explicitly using Application. I have no problem in it at XL 2010. — L42
– L42, Commented Apr 6, 2014 at 5:15

L42 · Accepted Answer · 2014-04-06 05:16:31Z

3

Try using Application and check if Intellisense picks up Cells property.
If so, replace your code by this:

Application.Cells(1, 1).Value = 1

answered Apr 6, 2014 at 5:16

L42

19.8k11 gold badges47 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

L42 · Accepted Answer · 2014-04-06 04:41:28Z

1

You have not commented the line

Cells(1, 1).Value = 1 'arrayint(i)

This may be the reason for error.

edited Apr 6, 2014 at 4:41

L42

19.8k11 gold badges47 silver badges70 bronze badges

answered Apr 6, 2014 at 3:58

RANGAN

261 bronze badge

Collectives™ on Stack Overflow

VBA - "Wrong number of arguments or invalid property assignment" - Cells()

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related