Roger Dodger explained :
Garry Mate,

All of your cleverness is wasted on me. Honest I don't have a clue when it
comes to VBA.

Maybe I could review your file if it contains clearly what you want and
an example of the expected results.

gesansomATnetscapeDOTnet

I pasted the text in and still couldn't get it to work.

Pasted it into what/where?

I think that I will have to buy a book and start way back at the beginning.

I re did the work using vlookup and other formulas and for the moment it
works. Unfortunately it is much slower.

Has VBA changed much since excel 2003?. That is all we have at work.

It hasn't changed (VBA6.x)since 2003 for x32 Office. VBA for x64 Office
is new (VBA7).

Thanks for you help, any book or web recommendations for learning VBA are
most welcome.

Anything by John Walkenbach is a good place to start. Also, google
Excel VBA and see what links pop up for tips/samples from Excel MVP
websites.

Thanks again

Roger

"GS" wrote in message ...
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



--
Garry

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