My aim is find value of E1 from colum A1:A100, and clear the contant of that celll..... without using Ctrl +F;
E2 =CELL("address",INDEX(A1:A100,MATCH(E1,A1:A100)))
this command give me a location. like id E1 =6 and A9= 6 than E2 give me value $A $9.
but now i want that, my cursor automatically go to the cell location A9 .
so i have que...how i can go at location $A $9 ?? and delete that value in $A $9.
Please help me on this topic...
Bookmarks