I am trying to lock a set of cells values using VBA but only if the last cell in the block is a formula and a date. So in the file i attached it would be cell BH4 and the cells that need to be lock would be all of Rows 4,5,6,7,8. But i need it to find amoung all cell in the BH coloumn. The actual file goes all the way to BH1978. Thank you in advace. Also the sheet I attached has had some informtion deleted so that personal infromation would be removed.Please Login or Register to view this content.
Bookmarks