Variable in Excel Cell Address? 2

[ChrisBurch]

Hi all,

Is the a way of using a variable in a cell address?

Such as:-

Dim RowNum As Integer
RowNum = 3

Range("C&RowNum&quot.select 'This doesn't work, but is intended to == C3

I've wriiten vba to sort a row of numbers, and I am trying to use RowNum to loop it through each row.
Thanks, Chris

It worked yesterday.
It doesn't work today.
That's Windows!

 

[JustinEzequiel]

try

Range("C" & RowNum).select

 

[SkipVought]

Hi,
Use the following method for referencing cells - works MUCH better than the Range("A1&quot method...

Cells(RowNbr, ColNbr).Select

or

Cells(RowNbr, ColNbr).Value = YourValue

Skip,
metzgsk@voughtaircraft.com

 

[SkipVought]

By the way, if you insist on using Range("A1&quot type notation, the way to accomplish this for your example is...

Range("C" & RowNum).select

Skip,
metzgsk@voughtaircraft.com

 

[ChrisBurch]

Thanks guys,

I went for Skip's suggestion. It is easier to handle. Chris

It worked yesterday.
It doesn't work today.
That's Windows!