I gave you a complete procedure, that if you copied it and pasted it into a
general module should compile without problem.

Now whether the functionality is correct or not - I haven't tested the logic
that Steve chose, but it appears to do what he describes.

--
Regards,
Tom Ogilvy


Allen Nance wrote in message
...


Thanks to both of you for your continued assistance.

It looks like the _ is a line terminator ?


The first thing I did was make sure the line mentioned on 1 line.

Line looks like this - lrow =
Workbooks("Feed.xls").Sheets("Sheet1").Cells(Rows. Count, _
"A").End(xlUp).Row



When I did this the " _ " before the "A").End(xlUp).Row errored with
invalid character and highlighted " _ "

so I removed the " _ " and made it look like this

lrow = Workbooks("Feed").Sheets("Sheet1").Cells(Rows.COUN T,
"A").End(xlUp).Row

Now when I debug I get a Compile error:

Sub or Function not defined

The word "Match" is highlighted. in the following line

Columns(2), Match(Workbooks("Feed.xls"). _

Now what? Was I wrong on the whole line? Or is it something else with
the command Match?

Allen

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!