Macro mode usually works better in arperture priority and as little zoom as possible. Of course it depends on the area you want to have the sharpest focus as to what f-stop you use. I've found that a lower arperture gives a better macro shot. For instance this one is;
Focal length 6mm
Arperture Priority
f-stop 3.2
Exposure time 1/2 second
Focus Spot metering
Exposure compensation +2
Distance Apprx. 3 inches
Macro mode