The first thing that comes to mind is that you could start with
something like this:

Do
x = x + 1
Loop Until Cells(1, x).Value = ""

This will run until it comes to a blank column. Then you can run the
code one way or another based on that number

If x = 8 Then
blah blah blah
Else If x = 10
blah blah blah
End If

That is just one example of how you can use the information. Let
me know if you need further help. - Pikus
:D


---
Message posted from http://www.ExcelForum.com/