How can I select complete rows to set up a data outline in VBA
Hi

I am working on a spreadsheet where I need to make the code put data outlines in as it inserts new rows. Clearly it is not a good idea to insertt complete rows which would copy the outline with the block of row because that would format the sheet to the default max width.


My issue is I cannot get the rows to select. " Row " seems to return the rows of a defined range rather than identify rows to be selected.
VBA Help is not a great help.