Link to home
Create AccountLog in
Avatar of Jagwarman
Jagwarman

asked on

Remove text from every sheet name

all of the sheets in the file are preceded with DOCS and I need to remove this from every sheet but keep the rest of the name.

So i.e.

DOCS GBP needs to be GBP

DOCS USD needs to be USD

etc
etc

can an expert provide me with vba code that will do this please.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Jagwarman
Jagwarman

ASKER

exactly what I needed thanks Rgonzo