Cell editing macro


Posted by Larry on October 16, 2001 4:02 PM

I am trying to create a macro that will edit characters out of a cell, then tab over to the next cell. The editing is done with "Home" "Delete" "End" and several "Backspace" keystrokes. The macro I have written fixes the first cell correctly. The problem is the contents of the first cell overwrite the contents of the next cell when the macro is fired. I understand "Relative Reference", and I am using it, but that is not the problem.... Thanks for your help...



Posted by Dan on October 16, 2001 6:26 PM

Hard to say. Can you paste the code? Go to Tools -> Macro -> View Code. You should see the code behind what you recorded and copy/paste it here.