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!
Did you record a macro when doing a Special Paste Validation and the same for the format ?
Send a short Excel sample to prepare it
- Battle without fear gives no glory - Just try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks