Making a Macro independent of worksheet

[AlexAsh]

Hello,

I have written a macro that works as I want in the worksheet it was written in. But, when I try to run the macro from the 2nd worksheet, the macro just runs in the original.
I think I must be missing an ActiveWorksheet, but I can't find where to insert it.

Thanks.

Sub SRRemoval()
Dim LR As Long, i As Long
LR = Range("D" & Rows.Count).End(xlUp).Row

For i = 2 To LR
 
  With Range("D" & i)
  If Mid(.Value, 4, 1) = "/" Then
  .Value = Right(.Value, Len(.Value) - 6)
  End If
  End With
  
Next i
End Sub

 

[bobhc]

Perhaps you should read,


http://chandoo.org/forum/threads/help-where-do-i-put-the-code.12112/

It is at the top of the page but you seem to have missed it.


.

 

[Hui]

Because your code doesn't define where it is running it will assume the active sheet is the sheet to act on

This may be due to you saving the code in the worksheet circled



The code should be in a code module highlighted in Yellow

Right click anywhere on your project and Insert Code Module

 

[AlexAsh]

Thanks, that has worked.

 

[NARAYANK991]

Hi ,

The code will also work if it is inserted in the ThisWorkbook section.

Narayan