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
- Please wait a few minutes to receive your 6-digit code before trying again. - Facebook Forum
- Vba case like - Guide
- Number to words in excel formula without vba - Guide
- If a cell has text then return value ✓ - Excel 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.
