Look up a number in an Excel page

[WHYME]

I need the code to look up a number set in an excel worksheet page.

PRINTERGROUP PRINT Max No. of Files 10

This is on a page called Report Option. I want it to look at the Max number of files number.

This is the code I have now. Can anyone see a problem?

Public Function GetMaxNumberOfFiles() As Integer

On Error GoTo erh

'Assign the value of the cell.
GetMaxNumberOfFiles = sheetReportOptions.Cells(sheetQueries.GetDestinationRow(maxNoFilesQuery), sheetQueries.GetDestinationCol(maxNoFilesQuery))
Exit Function
'Standard error handling.
erh:
AppShowError "GetMaxNumberOfFiles", strReportOptionsErrorName
End Function

 

[RalphA]

Assuming that you have the string, "PRINTERGROUP PRINT Max No. of Files 10" in one cell, cay cell C3, you could put this formula in another cell, say cell D3:
=RIGHT(C3,LEN(C3)-LEN("PRINTERGROUP PRINT Max No. of Files "))
This would show the number 10, in this case, in D3. Then, in your VBA code, you could simple refer to cell D3.