Posts by gowthamvt

[USER="179678"]chirayuw[/USER] I cannot use any loop statements.

I have created lot of objects created in different names. I have to dispose all objects created at once without any loop statements.

I am calling a function which is in another workbook. There , if i stop the execution the file is crashing. I am showing a temp function. In this file1 contains the code test() and the file 2 contains the function testFunc() and the return type of the testFunc is Object and when i stop the flow of execution then the file crashes. Kindly run the function and help me resolve this issue.

File 1:

Function test()

'Range("A1").DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, Step:=2, Stop:=500, Trend:=False

Dim RetVal1 As Object

Set RetVal1 = Application.Run("'" & "C:\Users\User\Documents\test2.xlsm" & "'!testFunc")

End Function

File 2:

Function testFunc() As Object

End

End Function