trim

[superbob]

Hi,

I need to trim additional spaces from cells within the below range

Please Login or Register  to view this content.

I'm not sure how/where to include it?

[sweep]

How about this?

Please Login or Register  to view this content.

You should dimension the rCell variable at the top of your code

Please Login or Register  to view this content.

[DonkeyOte]

It's not clear how the range is populated - presumably constants ?

If so you could get away with a single Evaluate call, ie:

Please Login or Register  to view this content.

It's not clear what appears after this range of interest - if anything - you might want to revisit the selection process as you could end up processing a very big range (unintentionally)

[superbob]

perfect, thanks very much!