In both of my spread sheets I have the same problem. Both sheets are the same except for how I present the calendar (1 with the calendar control, the other with VB Scripting). The problem is after the operators choose a date in column A and it is inserted, I offset 2 columns to column C (Hidden) where I wait for them to scan in a data string. This column remains hidden because of page size for printing and because I need to strip 2 characters off of the front of the data string to get the format I want in the column B. I needed the formula in column B to get desired data and present nothing (#VALUE) if nothing was entered in column C , Which would mess up my 'Print me' macro that sets print area to last cell with real data. My issue is that once the operators scan in the string in column C the active cell gets 'stuck' there. The data posts to column B as it should but the active cell remains C. The scanner appends a Tab command that should move the active cell over to column D but it doesnt (it works on cells with out the formula...) Even the Tab key on the keyboard will not Tab over from that cell. You have to mouse click to get out of it to column D. Is there some scripting or a macro I could use to get this over to column D? I am trying to automize this as much as possible for my users. I hope the explanation was not to long winded and made sense....