Roger Dodger explained on 10/7/2011 :
Its like your talking another language.

I'll give it a try when I get back to work on Monday.

Thanks for your help

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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc