"Macro Mode" question
 

When is the best time to use macro mode? Can one use macro mode to take pics of corals in the back of the tank (18 inches away)?

Macro mode simply allows the camera to focus on an object that is closer to lense than it could in normal mode. Say in normal mode you can only get with in a couple feet. In macro, you might be able to get with in a foot or closer, depending on the camera and focal length of the lense. If it's 18 inches away, your camera can probably focus on it w/o macro, but you may also have to stand back a little from the tank. In macro, your camera probably dosn't allow you to zoom in either, so it may seem as though you can't get as close. At least that's how my anceint 2 MP digi works. :)

macro mode will also change the shutter speed, the aperture (depth of field) and effect the operation of the flash if you have one. If you are trying to get really small stuff like pods, then you will have to be closer than 18 inches