How to DeSelect the Cell

[karthisucc9]

Hi All

I am new to Excel vba. In my project i have to Display RefEdit1. i have displayed. I have to save the data.

I have saved. My problem When i Move the up arrow in refedit1 the cursor position is displayed.

that means Sheet1!$A$1 is displayed.The curspor position is displayed. How can i deselect the cell.

When i move the cursor in refedit1 it should go up.

When i scroll the text in refedit1. the sheet is scrolling.

How can i avoid them.

I have upload the sample file also. Any help appreciable.

[abousetta]

Hi,

I am sorry but I don't follow you. Could you please explain further? Refedit does work the same as selecting on cell and holding down the shift button so that you can select a range. You will have to use the mouse for this. But again, I may be missunderstanding your question.

abousetta