Hello,

Quite simply I need to apply the Right Function to a dynamic range of cells. I currently have a series of numbers from Cell J2 in Sheet3, down to anything from J10 to J200000.

I then need the code to show these values in K2, but only with the last 10 digits (i.e. similar to the =RIGHT(J2,10) formula.

Many thanks,

Chris