I need to copy only those cell where comments is there in sheet
B Bernie Deitrick May 18, 2007 #2 Vimal, Select all your cells, then use Edit / Go To... Special Cells click "Comments" OK, then Copy Paste.... HTH, Bernie MS Excel MVP
Vimal, Select all your cells, then use Edit / Go To... Special Cells click "Comments" OK, then Copy Paste.... HTH, Bernie MS Excel MVP