How to get the last digit of a value of a cell to other in VBA ?
Closed
HARIKA
-
17 Apr 2013 à 02:21
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 17 Apr 2013 à 03:10
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 17 Apr 2013 à 03:10
Related:
- How to get the last digit of a value of a cell to other in VBA ?
- How to open vba in excel - Guide
- Vba find - Guide
- Samsung duos reset password 8 digit - Guide
- How to delete a cell in word - Guide
- Based on the values of cell b77 ✓ - Excel Forum
1 response
Zohaib R
Posts
2368
Registration date
Sunday 23 September 2012
Status
Member
Last seen
13 December 2018
69
17 Apr 2013 à 03:10
17 Apr 2013 à 03:10
Hi HARIKA,
The following macro will insert the last digit of the number in cell "I10" to cell "J10".
Sub MacroLastDigit ()
Range("J10").Select
Range("J10").FormulaR1C1 = "=RIGHT(RC[-1],1)"
End Sub
Please revert for clarification.
The following macro will insert the last digit of the number in cell "I10" to cell "J10".
Sub MacroLastDigit ()
Range("J10").Select
Range("J10").FormulaR1C1 = "=RIGHT(RC[-1],1)"
End Sub
Please revert for clarification.
