'Splits out the worksheet reference, if any, from a range reference.'

@staticmethod
def strip_ws_name(range_str):

    if ('!' in range_str):
        (sheet, range_str) = range_str.rsplit('!', 1)
        return ((sheet + '!'), range_str)
    return ('', range_str)
