GAutomation wrote:
Robert,
The manual Team wants it to be in the single sheet.
All i need to find is a method that can find an empty row before the next test case starts which i can use instead of usedrange which solves my issue.
You are operating at cross-purposes. The manual testing team has certain needs that are not necessarily compatible with an easily maintainable and adaptable automation framework. While it is admirable that you are trying to simplify things so that there is one source of data, that should not be the driver. Automation testing needs are, by their very nature, different than manual testing. They have needs for plain language... you have needs for easily adaptable data. They aren't 100% incompatible but you need to decide the ROI. You are spending time trying to get this code to work simply because you are trying to use their spreadsheets. Instead, you could go and create your own framework where the data you use for running your automation is stored separately from the documented manual test cases. That way you don't need to adapt your code every time they change the way they format their test cases.
I would suggest that this is best practice: separate the data sources. One data source for manual, another data source for automation, both of them have a COMMON root in the requirements and specification documentation from development.