Problem with dot.

[ljubo_gr]

Hi!
I'm moderatte Excel user. I have Office2016 regional setting coma decimal separator. When i open two or more workbooks and use this code to copy data to clipboard:

Sub Macro1_Copy_S12()
'
' Macro1_Copy_S12 Macro
'

'
    Sheets("LTV").Select
    Range("G21:G24").Select
    Selection.Copy
    ActiveWindow.SmallScroll Down:=-42
    Range("A1").Select
    Sheets("iTEMP").Select
End Sub
Sub Macro3_Copy_S11()
'
' Macro3_Copy_S11 Macro
'

'
    Sheets("LTV").Select
    ActiveWindow.SmallScroll Down:=9
    Range("F21:F24").Select
    Selection.Copy
    ActiveWindow.SmallScroll Down:=-36
    Range("A1").Select
    Sheets("iTEMP").Select
End Sub
Sub Macro4_Copy_S10()
'
' Macro4_Copy_S10 Macro
'

'
    Sheets("LTV").Select
    ActiveWindow.SmallScroll Down:=9
    Range("E21:E24").Select
    Selection.Copy
    ActiveWindow.SmallScroll Down:=-30
    Range("A1").Select
    Sheets("iTEMP").Select
End Sub

i end up with error. Well not quite error, but my numerical keyboard dot isn't coma anymore.
When i try to enter data in cell with decimal I have to use alphanumeric(left) coma. And i have to close all open books to restore defaut state. My in Excel setting is spelling&error checking in my own language, but display is in English(Match Windows system). Keyboard installed is in my language. Date&time is for Europa CET time.
Forrmatting in those ranges are General w/o coma thousand separator and with couple of values as decimals with coma separator(standard for EU).
Maybe, problem might cosing other workbook where i paste&transpose those values?

Private Sub pASTE_SPECIAL()
 On Error GoTo ifERROR

 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
 SkipBlanks:=False, Transpose:=True

ifERROR:
 Exit Sub
 End Sub

But, in this paste woorkbook i don't have problem with dot. Only in that starting Copy worrkbook.

 

[ljubo_gr]

Sorry! This thread is also this: http://www.mrexcel.com/forum/excel-...rns-into-dot-after-copy-code.html#post4547188

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).