Hi chandoo, i have created a excel macro that will copy a particular range of cells when clicking a button. its copying the selected whole area. but i m looking in that selected area, it has to copy only data not blank space. (Eg. in selected range of cells is ten rows and the data was only two rows. it has select only two rows not ten rows means not blank rows). Please help me out.