Excel - select named range
In excel it would be very handy to be able to directly refer to a named range rather than a cell address. I know this is possible using F5 (Goto) command and typing the range name but it would be considerably easier to have a direct reference from Winautomation to a range, the options could be to select the first cell (ie top left) of the range or the entire range itself.
This allows the structure of the spreadsheet to be flexible as you don’t need to know exactly where the named ranges are like , month, year, last_year etc. when setting up reports or headings.
3 people like this idea