Excel for mac qty in legend

broken image
broken image

The sub spits the table to the clipboard. It retains Dick’s option to use headers or not. With Dick’s green light, I created a Sub() that captures each cell’s font family, font style, and font color, as well as the cell’s alignment and background color. I loved that idea, and I asked if I could flesh it out. Dick very recently put up a function that takes an Excel range and whips up some HTML to create a table.