Navigating a WorkSheet

[MikeC14081972]

I'm using the ASCII value of characters to navigate an excel spreadsheet i.e.

' i is a long that relates to row number
.ActiveSheet.Range(chr(65) & i).select

My problem is I need to merge a number of cells on a given row dependant on data in another sheet.

I'm fine for columns A to Z but the problem I'm having is how to reference a value for Column AA as ASCII only has values for individual characters.

Any Ideas?????

 

[Chance1234]

build a string before hand

.....
Dim str_range as string 
....

str_range = chr(65) & chr(65) & i

.ActiveSheet.Range(str_range).select

before Skip asks, why the select ?

Chance,

F, G + yeah reached 50

 

[SkipVought]

Geez, Chance!

Well, I guess the sun does rise for y'all, a few hours before it does here, in Texas. ;-)

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[MikeC14081972]

Thanks Guys.

Had just done something like that ;-)