LinkBack URL
About LinkBacks
Assuming CW1 is spare cell, you can use this code to store present row nmber of Myname cell in variable A.
Range("CW1").FormulaR1C1 = "=ROW(Myname)" A = Val(Range("CW1").Value) Range("CW1").Value = ""
Assuming CW1 is spare cell, you can use this code to store present row nmber of Myname cell in variable A.
Range("CW1").FormulaR1C1 = "=ROW(Myname)" A = Val(Range("CW1").Value) Range("CW1").Value = ""
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks