Remove first 5 characters from a cell

Hi,
I have attached a spread sheet with some code I recoded with macro recorder.
I have been searching for some extra code to insert in the middle of the recorded code which will remove the first 5 characters from the active cell and past the result to the next page.
I have seen a lot of relevant code but havnt been able to get any to work in my code.

Please Login or Register  to view this content.

I am using Windows7 with Excel 2013.

I would appreciate some help with this.

Thank you,

To Sheet1 code module

Please Login or Register  to view this content.

Hello Holger and Jindon,
thank you for your replies.

After checking out both of your code I realised I made a mistake in my problem description so I am really sorry about that.

I only want to modify one cell at the time and this will be determined by the position of the cursor - and the result is to be pasted into the same cell each time - CellA2 on Sheet2

Jindon even though I made the mistake you still understood what I needed to do and your code pastes to the correct cell but I cant get the 5 first characters to delete?

Holger, your code deletes the first 5 characters perfectly but I cant just select one particular cell to modify.

Thanks to both of you for your efforts, I really appreciate it.
Peter

Originally Posted by PeterR

Jindon even though I made the mistake you still understood what I needed to do and your code pastes to the correct cell but I cant get the 5 first characters to delete?

What do you mean?

You said in the sheet2

When the cursor is placed in cellA1 of Sheet1 and the code is run then CellA2 and CellB2 on Sheet2 will contain the value 95

The code should do it.

Hi Jindon,

I have attached a screen shot of the result when I run the code.
I am not sure how to get it to delete the first 5 characters - maybe I am doing something wrong?

Regards,
Peter

Have you tried my attach file?

Whenever you click on a cell in A1:A10 on Sheet1, Sheet2!A2:B2 should have numbers.

Hi Jindon, I see how it works now – your code is very smart - I am sorry I didn’t know that could be done with VBA.
I still have a problem - my spreadsheet has quite a few cells spread around Sheet1 which need to be copied to positions on Sheet2 with the first 5 characters deleted.
I was hoping to have some code inserted in the middle of my original recorded code -

Please Login or Register  to view this content.

I don’t know much VBA so my plan was to make copies of this code and paste them into one routine one after the other then change the cell addresses in each copy to match all of the movements I need to make.
I know this is probably not very efficient but it is something I can work with.
Do you think this is possible?
Regards,
Peter

Is this the one you want?

Please Login or Register  to view this content.

Hi Jindon,
YES, YES! it works - thank you so much, it was starting to stress me out.

Really appreciate your help and patience, thank you.
Peter

No problem.

Can you mark this thread as "Solved"?