[thelist] Excel, VBA, Gurus? [Slightly OT]

Amazon Paulo Amazon.Paulo at Amazoniacelular.com.br
Tue Jul 16 10:18:01 CDT 2002


Jay,

>The statement 'Rows("  x  :  x  ").Select' throws a type mismatch errors. I
>have tried 'Rows(" & x & : & x & ").Select' and every other concatenation I
>could think of. Under normal circumstances this row would read (if I

Have you tried Range(x & ":" & x) ?

It seems to be the right concatenation here.

Paulo Guedes



More information about the thelist mailing list