Compile Error for defining a function in VBA

[QuestionBaker]

macroTest1 runs fine when the entire function is commented, but this error comes when I comment the function
I am using the following references

can someone help me with it?

 

[Fluff]

Change Sheet to Worksheets

 

[jasonb75]

It should be sheetName As Worksheet Sheet is not valid.

On a side note, the line Call defineVariables has alarm bells ringing.
Variables declared in a separate procedure will be meaningless unless they are declared as public, which means that they need to be cleared at the end of the code, they will not reset to default automatically.

 

[QuestionBaker]

@Fluff, that works...
thanks a lot
edit: @jasonb75 thanks a lot

 

[QuestionBaker]

@jasonb75 and @Fluff, would Sheets would instead of worksheets?

 

[jasonb75]

Sheets and Worksheeets are interchangeable as command lines in the code but not as declarations.