Call function from another worksheet

[simon105]

Hi, having a problem calling a function with multiple arguments in a macro. The function is contained within another worksheet. The function is this

[B]Public Function PoleCam(UpType, DType, PLength). [/B]

It is stored within MacroWorkbook.xlsm

and the first few lines of the macro I am using to call the function are these

Range("U2").Select
    ActiveCell = "Decider"

   
    
    Application.Run ("'MacroWorkbook.xlsm'!PoleCam(I3,K3,M3)")

[B]
    LastRow = Application.WorksheetFunction.Count(Columns("G:G")) + 2

[/B]

The middle line is the one im having trouble with, hoping its just a syntax problem?

Any help would be appreciated

Cheers

 

[cstimart]

Hi, having a problem calling a function with multiple arguments in a macro. The function is contained within another worksheet. The function is this

[B]Public Function PoleCam(UpType, DType, PLength). [/B]

It is stored within MacroWorkbook.xlsm

and the first few lines of the macro I am using to call the function are these

Range("U2").Select
    ActiveCell = "Decider"

   
    
    Application.Run ("'MacroWorkbook.xlsm'!PoleCam(I3,K3,M3)")

[B]
    LastRow = Application.WorksheetFunction.Count(Columns("G:G")) + 2[/B]

The middle line is the one im having trouble with, hoping its just a syntax problem?

Any help would be appreciated

Cheers

Change the middle one to:

LastRow = Cells(Rows.Count, 7).End(xlUp).Row + 2