The attached has worked very well - Excel 2010 in Windows 10 The attached sub routine loops through a list of sheets and for each sheet calls in the arguement also shown.
direct dating summit direct seduction gurus alan roger currie - Vba screenupdating excel 2016
The problem is...unlike macros that hide or display columns, the VBA code...
There are about 100 copy pastes) Sub Copy Validation() ' ' Copy Validation Macro ' ' Application.
Range For repeat = 1 To 30 For Each cell In r cell. Value Mod 2 = 0) Then ' if i is even, color the cell white cell. Range For repeat = 1 To 30 For Each cell In r cell. Value Mod 2 = 0) Then ' if i is even, color the cell white cell.
I have seen the other posts on this topic, where the property does not function in Excel 2016, but there still does not appear to be a remedy for this problem.
I am sure that the coding could be improved but you don't add any notes to explain in the code.