Simple VBA code working in both english german and french versions of excel?

[mboas]

Hello friends.

I have a code i used in several worksheets, however some are german french and english - how do i make sure the same code works in all - or alternatively, how do i figure out the other language variations to the same code? The code is below and works fine in english excel but not in german.

I have the following code:

Sub CloseMonth()    Sheets(1).Select
    For j = 2 To Sheets().Count - 2
        Sheets(j).Select
        Col = Range("B20").Value
        Range("K2:K9").Select
        Selection.Copy
        Cells(26, Col).Select
        Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
            False, Transpose:=False
    Next
    Sheets(1).Select
    Calculate
End Sub

Any help would be greatly appreciated.

 

[BerndKuerzinger]

Hi mboas,

Are you sure this code is not working in a German version of Excel? VBA should be language-neutral to my knowledge, especially the parts you are using above.
Could there be another reason your code does not work in the German version you are testing with?

Regards,
Bernd