LutonBarry
05-19-2016, 08:52 AM
Folks, I keep asking you all these questions and I'm learning an awful lot from you all so thanks very much.
The attached spreadsheets function is to rename the Resolver Group names in the rows beneath depending on the colour so 'Dtop-Red' or Dtop 'Ambr-Grn'. Then select and paste those groups into the respective worksheet tabs.
It works a treat if there are not Red rows or more than one. But if there is only one Red row the cell P2 is renamed after cell P1.
I cannot seem to think of a method around this, I've tried but without success.
I'm hoping /sure someone on this fine forum can come to my rescue and no doubt have a giggle at my code and simplify it even more.
Thanks in advance for all your help.
The attached spreadsheets function is to rename the Resolver Group names in the rows beneath depending on the colour so 'Dtop-Red' or Dtop 'Ambr-Grn'. Then select and paste those groups into the respective worksheet tabs.
It works a treat if there are not Red rows or more than one. But if there is only one Red row the cell P2 is renamed after cell P1.
I cannot seem to think of a method around this, I've tried but without success.
I'm hoping /sure someone on this fine forum can come to my rescue and no doubt have a giggle at my code and simplify it even more.
Thanks in advance for all your help.