If you have nothing to the right of col Z that you want protected, you couldmake itsheet1.ScrollArea = "A1:IV100"