2 very easy excel vba questions...
Posted on 2000-03-21
Usually I figure out vba stuff with help, but since it's missing and i don't have admin privelages, here goes:
Want to make a little 'macro' hooked on the change sheet procedure to change the color of the cell text (of a bunch of cells from A1 to Z40) if the value is #N/A... (which would probably entail changing it back to it's original color, too...but I can figure that out from an answer to the above)
While I'm at it, might as well ask about a macro for a time date stamp. Something along the lines of changing a cell to the current time and date which I'd hook to the beforesave action.