Hi K_Macd,

Thanks for this tip, helped me to resolve a difficult situation
(similar to your scenario).

regards,

DaveU

On Aug 26, 7:45*am, K_Macd <kmacdonald "A_T" activ8
''''''''''''''''''''''''''''''''D O T''''''''''''''''''''''''''''''''
net [S wrote:
Another variation is to use a 'helper' row in which you place a flag to
denote whether you want to hide the column eg "**HIDE**" then have a macro go
to the last column and work backwards testing each cell in the row for the
flag to determine whether to hide the column.

At my work I have a number of files where columns need to behiddenfor
presentation purposes but shown during preparation. With this method one can
write universal code that sits outside each of those files but operates on
each file as long as a helper row is defined.

I can post code if anyone is interested.

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"