Define worksheet to run macro

[Isacael]

Hi All

I have this code, but it runs in all worksheets. How to I adjust this so that it only runs on the selected range, but only in the worksheet I define? Ie, I only want it to run in worksheet called "Budget".

Sub NoSpace()

Dim sh As Worksheet
For Each sh In Sheets
sh.Range("O9:O500").Replace what:=" ", replacement:=""
Next sh
End Sub

Cheers
Isacael

[TMS]

Is this what you want:

Please Login or Register  to view this content.

[Isacael]

Perfect, thanks TMS. Another request... Can you add some code that will trigger this macro when user exits the cell?

Cheers
Isacael

[Sintek]

If it is a selected range then you do not have to define the sheet...