How to get the last digit of a value of a cell to other in VBA ?
Closed
HARIKA
-
Apr 17, 2013 at 02:21 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 17, 2013 at 03:10 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 17, 2013 at 03:10 AM
Related:
- How to get the last digit of a value of a cell to other in VBA ?
- Samsung mobile reset code 8 digit - Guide
- Vba case like - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- 5 digit unlock code for ninja up - Phones, PDA & GPS Forum
- Please wait a few minutes to receive your 6-digit code before trying again. ✓ - Facebook Forum
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 17, 2013 at 03:10 AM
Apr 17, 2013 at 03:10 AM
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.
