I'm pretty confident it's trapping the right error, at least in that i
calls the loop the correct number of times (well, given that the name
aren't being changed ...)

I also noticed that when I tried to MsgBox the value from the cell I'
naming it based on, it refuses to. Flat out, it just ignores my msgbo
line entirely. ie:

MsgBox wksData.Cells(intRow, VendorNameCol)

or same .value or same .Text

none of these work at all, and if I do
MsgBox "I created a sheet for " & wksData.Cells(intRow,VendorNameCol
(and .value, and .Text)
it still refuses to write anything in a msgbox (even the string at th
beginning) ...

Thanks!
-Jo

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