Thank you that has helped alot. I do have one minor problem regarding the reference talbe which has happened before. I want to be able to have the entries scroll up. When I highlight the first two rows and click on freeze it actually freezes the table down to row 10. why is this and how do i get over it?