Some of us can run macros fine, but others can not...

Please post the VBA code - it's unlikely to be random, but unless we know what's in the code and at which point it is causing the error, we can't begin to help.

Hi,

I tried to attach the xlsm but it wouldnt let me. Ill paste the code below instead.

Cheers!

Sub Outdated_LatinsEng()
'
' Outdated_LatinsEng Macro
' Replaces outdated latins with the new versions
'

'
    Range("Table1[[#All],[Scientific Name]]").Select
    ActiveWindow.SmallScroll Down:=-40
    Columns("C:C").Select
    Range("C20").Activate
    ActiveWindow.SmallScroll Down:=-65
    Range("Table1[[#Headers],[Scientific Name]]").Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlDown)).Select
    ActiveWindow.SmallScroll Down:=-125
    Selection.Replace What:="Acanthis cabaret", Replacement:= _
        "Carduelis cabaret", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:= _
        False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:= _
        xlReplaceFormula2
    Selection.Replace What:="Carduelis cannabina", Replacement:= _
        "Linaria cannabina", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:= _
        False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:= _
        xlReplaceFormula2
    Selection.Replace What:="Carduelis linaria", Replacement:= _
        "Linaria cannabina", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:= _
        False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:= _
        xlReplaceFormula2
    Selection.Replace What:="Lacerta vivipara", Replacement:="Zootoca vivipara" _
        , LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat _
        :=False, ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
    Selection.Replace What:="Triturus helveticus", Replacement:= _
        "Lissotriton helveticus", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase _
        :=False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:= _
        xlReplaceFormula2
    Selection.Replace What:="Triturus vulgaris", Replacement:= _
        "Lissotriton vulgaris", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase _
        :=False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:= _
        xlReplaceFormula2
    Selection.Replace What:="Calaena leucostigma", Replacement:= _
        "Helotropha leucostigma", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase _
        :=False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:= _
        xlReplaceFormula2
    Selection.Replace What:="Celaena leucostigma", Replacement:= _
        "Helotropha leucostigma", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase _
        :=False, SearchFormat:=False, ReplaceFormat:=False, FormulaVersion:= _
        xlReplaceFormula2
    ActiveSheet.Shapes.Range(Array("Button 3")).Select
    Selection.Delete
    Range("R3:S6").Select
    ActiveCell.FormulaR1C1 = "Rename latins done."
    Range("A1").Select
End Sub

Is your code being called automatically when the workbook opens?

No it is launched when clicking a button with the macro assigned.

This is the bit highlighted when clicking debug.

Attachment 685626

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new, I have done it for you today.)

Your attachment doesn't work, by the way. Which line is highlighted?

Are you all using the same version of excel?

The online help suggests the replace method uses these arguments
expression.Replace (What, Replacement, LookAt, SearchOrder, MatchCase, MatchByte, SearchFormat, ReplaceFormat)


The object browser in O365 returns
Function Replace(What, Replacement, [LookAt], [SearchOrder], [MatchCase], [MatchByte], [SearchFormat], [ReplaceFormat], [FormulaVersion]) As Boolean


FormulaVersion appears to be a new argument.

The post a workbook, currently none of you links are working.

There is a big yellow banner at the top of the page with instructions on how to post workbook

Can you just tell us which line is highlighted by the debugger?

Since there aren't any line numbers in your code, could you just paste the line here?