I did it! It finally works. I had entered the references in ColumnList etc.
with quotation marks so they appeared in the set statements with two
quotatiion marks in front and two behind. Something you said gave me a clue.
Thanks for the patience, Jim. This was not an important project, but it was
sticking in my craw. I really appreciate the help.

"Jim Cone" wrote:


I'll give it another try, however things are still not clear.

Once you have established (set) a range object you do not qualify it when
you use it. Assuming the range object SelectCell refers to WS1.Range("B5") then
WS1.Range(SelectCell).Value = 44 fails, while SelectCell.Value = 44 is valid.

However, the address of a range object is a string and the string has no reference
by itself to any particular worksheet. So the string (address) can be used
with the Range method on another sheet...
WS2.Range(SelectCell.Address).Value = 123 is valid and is the same as
WS2.Range("B5").Value = 123
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Jerry McNabb" wrote in message ...
Okay, I finally got the message through my head. It means that The error is
one I defined in the application or one defined by the object. Is there any
way to find out what this error is?