Hi, dear excel vba.. masters!
I have VBA code in Module1,2,3,4
In Module2:
Module4:
With module4 I call private sub from module2, now I have problem, cache won't clear!?
Before module4 I run code w/o calling, directly from module2, cache than clear.
Reason for Module4: now I have a object called "PASTE VAL.&TRANSPOSE" inside excel sheet.
Thanks in advance! kind people!
I have VBA code in Module1,2,3,4
In Module2:
Code:
Private Sub pASTE_SPECIAL()
On Error GoTo AkoGRESKA
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=True
AkoGRESKA:
Exit Sub
End Sub
Module4:
Code:
Sub Zalijepi_LetveiTemp_Obratno_Click()
Application.Run "pASTE_SPECIAL"
End Sub
Before module4 I run code w/o calling, directly from module2, cache than clear.
Reason for Module4: now I have a object called "PASTE VAL.&TRANSPOSE" inside excel sheet.
Thanks in advance! kind people!
Last edited: