I know I've seen that before in the NG. This is what I use to do searches
the
http://www.rondebruin.nl/Google.htm. Try it out. With "columns numbered"
as search criteria, I got this one that might be useful to you:
http://groups.google.com/groups?hl=e...as_uauthors%3D
(All of that is supposed to be one line of URL - I don't know how to make
them smaller. You might have to take out some line breaks to make it work.)

HTH
Ed

"ZoomZoom " wrote in message
...
If that works, then step
through it with the macro recorder and go from there.

That's it!
I didn't realise you could do that, how bloomin' useful!

Right, the problem is entirely because I'm trying to do things on a
sheet other than Sheet1. As soon as I do it all entirely on sheet1 I'm
flying - it appears the validation has to be added with the cells on
Sheet1 selected, otherwise it doesn't work.

Another problem was obscuring this one though: My columns are numbered
rather than lettered, and I can't refer to cells as A1:B4, I have to
use R1C1:R4C2.
What on earth is going on in this case?

Thanks very much for your help here.

Justin


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