West Cumbrian Rio Hardy said it was a "sweet" feeling to score for Rangers against Celtic and secure a cup final place.