View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Fix the reference cell

Try just copying A2 to A3 (or row 2 to row 3) and then deleting the
contents of A2 (or row 2).

Hope this helps.

Pete

On Dec 9, 1:12*am, Help!!!!!!!!!!
wrote:
Hi,

IF A2 is the referce cell for the if formula & reuslt cell is A1,

If i cut A2 Row & palce it in A3 the refrence cell should be to the same
place.

Please help me in solving the same.

Thanks & Regards,
Manjunath