I have a very strange problem. To fill out this data i use a worksheet change event. For some reason the code (LHS-1) on line one is offset from the code (LHS-2) below it and this is causing other problems when i try to run formulas which might use this code. Its only line one that has this problem and all cells are set to general formatting. When i drag and fill from the cell below it, it aligns correctly and formulas work then but when new data is entered and the worksheet change event is triggered its the same problem again. Note that the code that fills line one also fills other lines so i don't think is a problem with the code but its also the event that causes it so this is why its confusing.