H Helnora New member Jan 12, 2018 #1 In the VBA compiler I call another function also inside the VBA compiler. I do not get errors when compiling. I get the following error, but do not understand what is wrong.
In the VBA compiler I call another function also inside the VBA compiler. I do not get errors when compiling. I get the following error, but do not understand what is wrong.
gdgsupport Support Staff member Jan 13, 2018 #2 The compiler tells you there is an error in the VBA code. Check at the position indicated (9, 53).
H Helnora New member Jan 15, 2018 #3 I really do not know what is wrong. This is the line: sheettest = Application.testSheetName(WName) testSheetName is another function that is also in the VBA compiler.
I really do not know what is wrong. This is the line: sheettest = Application.testSheetName(WName) testSheetName is another function that is also in the VBA compiler.
gdgsupport Support Staff member Jan 18, 2018 #4 Then if this is a function already in the compiler just invoke it without Application. sheettest = testSheetName(WName) The compiler will recognize the function
Then if this is a function already in the compiler just invoke it without Application. sheettest = testSheetName(WName) The compiler will recognize the function
H Helnora New member Jan 19, 2018 #5 Without “Application” then compiler says “unknown method or routine: ‘tesetSheetName’”.
gdgsupport Support Staff member Jan 19, 2018 #6 Make sure the testSheetName is declared before the call to it. Last edited: Jan 22, 2018