Hi I try this code, but I will not work.
sub selectnamedrange(fblock as Integer)
dim frow_string
frow_string = "f" & fblock & "_frow"
Range(frow_string).Select
' Which is translated into Range("f1_frow").Select
' f1_frow is a named range in the current worksheet.....
' The sub contains more code, but this is the part that does not work....
end sub.
Any hints appreciated
Mr. Smith
Bob Phillips - 27 Sep 2006 10:34 GMT
Works fine for me. Are you sure that fblock is 1?

Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
> Hi I try this code, but I will not work.
>
[quoted text clipped - 11 lines]
>
> Mr. Smith
Mr. Smith - 27 Sep 2006 11:58 GMT
Works now....
Needed ActiveSheet.range instead of just Range
thanks anyway Bob
Kind regards
Mr. Smith
> Works fine for me. Are you sure that fblock is 1?
>
[quoted text clipped - 13 lines]
>>
>> Mr. Smith