the Lens Nikon 24 PC-E who is a fantastic lens for architecture can also be used for macro, the tricky part this lens is manual only,
I know normaly not an issue for macro but try to follow a Bubble Bee with a Manual lens handled and we can talked about it.