Thanks to all of you who replied. I was trying to get too close to the subject in max telephoto, which I have since found out is a minimum of 55cm, quite a distance for macro work! Guess this camera isn't going to be too good for macros. Still impressed with By-eye's ladybird taking off and other pics posted a few hours ago though.
And the controls are taking a little while to explore. It's not the most intuitive camera. Bought a Panasonic G3 last year which I have loved. The RX100 was to be a camera to have with me at all times. Will persevere!