>>How many columns are returned in
lnCols = .UsedRange.columns.count
>>
>You're right to the target! It's 40 and I just found that chr(64+40) is "h" and not AN as in Excel. So, how can I specify range not using letters?
>
>In other words, if I need 40 columns and 10 rows, how can I select this range?
>
>Thanks a lot in advance.
UsedRange.Select works fine (except for Arabic problem) Now I'm wondering, if I can always use UsedRange.Select instead of trying to calculate range in my more complex version of the code.
If it's not broken, fix it until it is.
My Blog