Previous Topic Next Topic

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
Hello,

I am trying with vba excel that how to get the last digit of a value in one cell to other.suppose I am trying to the get last digit of 99281 on I10 to J10. Digit 1 should be copied to J10. Please help me with the VBA code


1 response

Answer 1 / 1
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
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.

Similar discussions

Please wait a few minutes to receive your 6-digit code before trying again.
Meraj113 -
Carmine007 -

Hello,
One number two facebook account and i dont get recovery code in my number. any one helpme plz...

6 responses
6 digits codes aren't being received on my phone new phone same number
gregoryrobinson -
HelpiOS -

Hello,

the 6 digits codes coming to **** to log into my facebook account isn't coming . I've gotten a new phone but has the same number . also my facebook app was never signed out . so why aren't I receiving the codes . phone isn't blocked from receiving them so please help. Thank you for your time and help

1 response
help me to add particular cells
mathewmunna -
mathew munna -

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

2 responses
Facebook You Entered 6 digit code too many times
Kasia16 -
Kasia16 -

Hello,

I was told by Facebook that my account has been hacked and I need to reset my password. I was able to receive the 6 digit code via email but as soon as I enter the code this message pops out! "You Entered 6 digit code too many times or please wait few minutes to receive your 6 digit code before trying again" also when I try to change my password on Facebook app I get a message unknown errow. Please help!!!!

System Configuration: iPhone / Safari 10.0

2 responses
4 digit password on LG smart TV
maryjane -
owilson -

Did not keep the instruction booklet with the 4 digit password for the rest to factory default setting.

2 responses