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...