i have assignes value and the id to the cell.
If u save the sheet and close it.
U will get the cell value as 10 but ID value as blank.
could u plzz tell me the way to save the ID permanently like the
cell.vba code given below:
Private Sub Worksheet_Activ ate()
Me.Cells(1, 1).ID = "ID1A"
Me.Cells(1, 1).Value = 10
End Sub
Private Sub Worksheet_Selec tionChange(ByVa l Target As Range)
MsgBox Target.ID
End Sub
If u save the sheet and close it.
U will get the cell value as 10 but ID value as blank.
could u plzz tell me the way to save the ID permanently like the
cell.vba code given below:
Private Sub Worksheet_Activ ate()
Me.Cells(1, 1).ID = "ID1A"
Me.Cells(1, 1).Value = 10
End Sub
Private Sub Worksheet_Selec tionChange(ByVa l Target As Range)
MsgBox Target.ID
End Sub