Calling procedure from a sheet in Excel
Calling procedure from a sheet in Excel
(OP)
I am calling a procedure called TRET from an UserForm. TRET is located in sheet6. Here is part of my code:
If A=1 then
sheet6.TRET
else
call SUGAR
end if
The problem is that I can't call TRET from sheet6!! It says that there is a "Type mismatch". What I am doing wrong!!
If A=1 then
sheet6.TRET
else
call SUGAR
end if
The problem is that I can't call TRET from sheet6!! It says that there is a "Type mismatch". What I am doing wrong!!





RE: Calling procedure from a sheet in Excel
Chances are you've got a string that you're trying to stuff into an integer somewhere inside that subroutine TRET.
RE: Calling procedure from a sheet in Excel
Thanks again for your help.