Function only works for column A. How to adjust for other columns in a sheet?

[MaartenRo]

Hi,

A forum contributor gave me this macro which works perfectly. It shows the substring after the last "/" in the string.
This function works for column A. I would like this formula to work for other columns as well. I changed "A2" for "W2" but it doesn't work. How can i adjust this function to work for example for column W?

Please Login or Register  to view this content.

[jolivanes]

Hoi Maarten
If you change everything that realates to the first Column (A or 1), as you partially did, you're in business.

Please Login or Register  to view this content.

en

Please Login or Register  to view this content.

[MaartenRo]

Thank you for your input. I applied the changes. Somehow i get a runtime error 13: types mismatch.
How can i solve this?

Please Login or Register  to view this content.

[jolivanes]

Can you try this in the meantime?

If there are possible different Columns at times, this might fit you better.
Just select a cell in the column that you want to run the macro on with your mouse when asked.

Please Login or Register  to view this content.

[jolivanes]

In Post #1 you have a backslash ("\") and now you have a period ("."). Is that right?
Do you have data in Column W?

It's getting late here so if no one else jumps in, I'll have to check again after my beauty sleep.