Hey all,
I am trying to write a macro where I can copy data validation settings + formatting settings from a certain range (for example Sheet1 C3:C27) to a new range that is located 4 columns further from the original (same example: new range sheet 1 C(3+4=7): C(27+4=31)). I can't write it! May you please, help?! Thanks a lot!