Thanks Steffen. Found my problem. I was running macro from Debug. However when I just ran the macro normally, all is OK.
I do need the ScreenUpdate.False code to avoid viewing the jump from cell to cell as data is input. When a row is complete, switching to ScreenUpdate.True displays the updated sheet.