Error 5: Invalid procedure call or argument

[GiANTOnFire]

I keep getting Error 5 when trying to run my code. It seems to be this line that it has a problem with but I have no idea why:

number = Worksheets("Front").Cells("C10").Value

I have declared number as an integer.

Any ideas?!

 

[Fishboy]

I keep getting Error 5 when trying to run my code. It seems to be this line that it has a problem with but I have no idea why:

number = Worksheets("Front").Cells("C10").Value

I have declared number as an integer.

Any ideas?!

Hi GiANTOnFire, welcome to the boards.

If you are going to use "Cells" then C10 would be Cells(10,3) , not Cells("C10").

I think you probably mean:

number = Worksheets("Front").Range("C10").Value

Or

number = Worksheets("Front").Cells(10,3).Value

 

[GiANTOnFire]

Ah yes! of course - that comes of staring too much at code, and teaching yourself VBA, probably badly... Thank you!

Hi GiANTOnFire, welcome to the boards.

If you are going to use "Cells" then C10 would be Cells(10,3) , not Cells("C10").

I think you probably mean:

number = Worksheets("Front").Range("C10").Value

 

[Fishboy]

Ah yes! of course - that comes of staring too much at code, and teaching yourself VBA, probably badly... Thank you!

No worries, happy to help.