At the lower limit, if the bubble is very small the pressure inside will be so large that the gas inside can dissolve into the shell of the bubble, and from there diffuse out to the atmosphere. That limits the life time of small bubbles.
On the large side, huge bubbles (several meters diameter) are certainly possible. These tend to be unstable because they require extremely low surface tension, and thus they don't "keep their shape" very well. Over time they evaporate, or the soap molecules migrate causing an uneven distribution of surface tension along the surface. With insufficient surface tension in some places the bubble will once again burst.
In the absence of evaporation and instability, the ultimate size limit of a bubble may have to do with gravity: the film somehow needs to support the "column of soap bubble" above it, and if you think about hanging a soap film from a thread, you can see that it would be thinner at the top (which is supporting more weight) and thicker at the bottom. There will be a limit beyond which the film cannot support its own weight - I don't know how to compute it.