Can anyone tell me why this isn't working? .offset

Please Login or Register  to view this content.

I'm following other vba code I've seen doing this and I can't pinpoint where I'm goofing up.

Run-Time error '1004':
Application-defined or object-defined error

From what I can tell, this should take the value in txtVendorName and put it into cell column A of the row below the last line of the named range VenderList. I have a ton of items I need to add to the named-range, so once I figure out this small thing, it's a much larger world. FYI, the next line of code I didn't include extends the named-range by +1.

How is 'VendorList' defined?

=vendors!$a:$o

I should mention I use it with vLookup without issue, i.e.:

Please Login or Register  to view this content.

It is defined as full columns. So your row count will be the number of rows on the worksheet. So, you can't offset from that.

Regards, TMS

You're welcome. Thanks for the rep.