Reply to thread

Message: [QUOTE="GS, post: 6656819"] Roger Dodger explained on 10/7/2011 : You're welcome! I assure you the language is VB[A]! I also hide/unhide rows/cols the same way... Const sColsToHide As String... Const sColsToUnhide As String... Const sRowsToHide As String... Const sRowsToUnhide As String... vColsToHide = Split(sColsToHide, ",") vColsToUnhide = Split(sColsToUnhide, ",") vRowsToHide = Split(sRowsToHide, ",") vRowsToUnhide = Split(sRowsToUnhide, ",") This works for fixed cols/rows. For unknown cols/rows I build the strings at runtime. Might help if you post the actual code you have now. [/QUOTE]