Hi

Below is code that starts at the end column of the sheet on row 7 and looks
for the last text column, however it totally ignores hidden columns is there
a way to get it to use the right value and look at hidden columns?

Thank you
Jeff

Dim col_address As String

col_address = ActiveSheet.Range("IV7").End(xlToLeft).Address
MsgBox col_address




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----