HI, I want to update the range of the name tab and also the formula. I am using wizard to generate the wrapper classes like CRange, CName, CWorksheet etc. My idea is to read the row till it is empty and get the range and update the rformula of the particular name tab. As I am new to this I am not gettin how to do. Anyone pls help. Thanks in advance.