I have a workbook in which cells B1 to B3 are protected. The cells B4 to B2000 are filled up depending on the formula which is copied down to B2000. The Cells are filled up in continuation from B4 to down but every time the last filled up cell is different. Some time it is filled up up to B50 or B83 or B1000 etc. To select data upto the last filled up cell of column B, I can use the macro Range("b4", ActiveSheet.Range("b4").End(xlDown)).Select and this is perfect if there is no formula in column B but if the column B has some formula which is copied way down for e.g B2000 and the data received is up to e.g B50 this macro instead of selecting upto B50, is selecting upto B2000 even the cells after B50 are blank. I presume that excel is treating the formula in that cells also as a filled up cells. Please advise any other macro or command to select upto the actual filled up cells andd not upto the total cells where formula has been copied down. Thanks