Hi ,
Anyone can tell me the Vb code in Excel for copying the data from onc cell to another cell without changing the format..


When i use like
cells(2,2) = cells(1,1)

It's copied the value but not the exact format ..


Thanks in advance