Calculating Working hours in a Week

[surya prakash]

Hi Paul,

Many thanks for your prompt response.

I am getting "Method "Range' ofobject'_Global" failed" error when i add "range" ;

Please could you have a look at attached sample file.

regards

try this, assuming that myLocation = a cell named 'myLocation'

If myLocation = "WHUK" Then
    Set myHolidays = Range("Hols_WHIL")
ElseIf myLocation = "WHPHL" Then
    Set myHolidays = Range("Hols_PH")
End If

Paul