range("a1") or cells(1,1) or [a1]

[RSXchin]

When should I use what? Do they have different object properties?

 

[Andrew Poulsom]

They are equivalent.

 

[RSXchin]

always? why would I bother EVER typing out Range then?

Okay, so the following works
[a1:b5] = "this"

but I can't use variables for row numbers. Is there a way to do that?

dim i as integer
i = 5
[a1:b & i] = "That"

 

[JamesW]

Hi,

An interesting read here:

http://www.xtremevbtalk.com/showthread.php?t=310029

always? why would I bother EVER typing out Range then?

Range("A1:D100") cannot be done on its own using Cells().

 

[RSXchin]

Hi,

An interesting read here:

http://www.xtremevbtalk.com/showthread.php?t=310029



Range("A1:D100") cannot be done on its own using Cells().

but you can annotate that as [A1:D100]

 

[Jonmo1]

Range("A1") - We all know

Cells(1,1)
Advantage: you can use Column NUMBER or Letter (can't with Range)
Disadvantage: Can only refer to 1 single cell or ALL Cells, not a finite range like A1:B10

[A1]
Advantage: Easy to write...
Disadvantage: Cannot use Variables or Column Number.

 

[RSXchin]

Range("A1") - We all know

Cells(1,1)
Advantage: you can use Column NUMBER or Letter (can't with Range)
Disadvantage: Can only refer to 1 single cell or ALL Cells, not a finite range like A1:B10

[A1]
Advantage: Easy to write...
Disadvantage: Cannot use Variables or Column Number.

There we go! alright then, range and cells it is. Thanks guys!