I have a macro that runs with every entry in a worksheet named "A".
When I write macros that reads and writes data to and from worksheets, I typically create a dummy worksheet where the data is stored simply to avoid formatting changes in the main worksheet from affecting the macro.
Therefore...