El Belgio wrote ...

I'm not an Excel specialist, but I work with SAP BW (which uses Excel
as a front end).
I have a similar issue where I need to fill a string with cell
addresses to launch an SAP defined macro. I also noticed that the
String variable is limited (Variant as well by the way).
Isn't there any data type that can take more than 185 characters in
VB?

What are we talking about here?

I had a look in my archive of recently executed queries and the
largest is 2573 characters. I've never had a problem with SQL string
length with ADO.

AFAIK, the SQL property is limited in 'QueryTables' (i.e. MS Query)
VBA code to 255 characters and this limit is circumvented by using an
array where each element is within the 255 limit.

If you are talking about the VBA6 native String type, the limit is
2^31 characters (approx 2 billion).

--