AJ is spot on. Talk of 7 yards, 10 yards, etc., stems from self defense shooting.
There are those people who literally can't hit the broad side of a barn though, sometimes because of poor shooting practices and sometimes for physical or medical reasons. There is nothing more frustrating than shooting and not hitting what you're aiming at, and for that reason, there's nothing wrong with shooting at close distances.
My reply was only to dispel the myth or belief that snubies can't be shot at 25 yards. There are those among us who can do quite well with them at that distance. And those among us (raising hand here) who simply need a bit more practice. In shooting, practice doesn't always make perfect, but I'd rather practice shooting than practice with a violin (which would annoy a heck of a lot more people!).
Practice at whatever range you want to, and if you get better, try further distances. And one more thing: shooting is unfortunately looked upon as a macho sport, and many people,
especially guys, are afraid they'll have to turn in their man card if they ask for help. Shooting isn't different that any other sport, and everyone can benefit from sagely advice from a professional or someone who is better. Equally unfortunate is most ranges don't have that kind of help available. That doesn't mean you can't ask someone, such as a friend or even a complete stranger for guidance. A lot of times, it turns into something simple (squeeze instead of jerk!).