How to use "cells" property?

[GIS2013]

Hi, any error here? It just refuses to work..

Please Login or Register  to view this content.

[HaHoBe]

Hi, GIS2013,

the range must go from 1 (Row 1 and Column A) to 5 - no Row0 or Column0 present in worksheet.

Ciao,
Holger

[GIS2013]

Hi, Thanks! , rather logically I must agree. Now working on my next question, to be posted soon. You're great guyz.

[mehmetcik]

Hi

you are trying to put a number into cell 0,0

The first cell is 1,1 ie A1.

Also why are you using a for next loop when that could be done as one instruction?
see below.

Please Login or Register  to view this content.

[GIS2013]

Hi, your solution is really more efficient than mine. thanks for that.

*Just to be sure. Can I replace these specific digits with variables?

[HaHoBe]

Hi, GIS2013,

Please Login or Register  to view this content.

Ciao,
Holger

[GIS2013]

great. Feel much comfortable with CELLS now.