I didn't look at the other post and I didn't notice a connection.


Arvi Laanemets wrote:

"Dave Peterson" wrote in message
...
Excellent point!

I'm not sure what the newsgroup etiquette is for different
languages--maybe one
post with the question in German followed by the translated question???

But my point about using application.worksheetfunction raising an error
still
needs addressing (I think).

Look at my another posting from yesterday (Excel2000 VBA: How force the
procedure to wait until queries are refreshed?). It's not the same procedure
I was speaking about here, but another one from same application. It
contains almost same code for deleting of rows. As you can see, the code row
with application.worksheetfunction is processed only, when varDate is found
in range DataDate.

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


I didn't see anything in your original short snippet that would show that
you're
looking for that kind of error.

Arvi Laanemets wrote:

Hi

"Dave Peterson" wrote in message
...
If that date isn't found, you may still have a problem.

No problem in my procedure (at least this code row). This row is from
delete
routine which is a part of procedure. User is asked for source workbook,
and
then for date. When returned date is found in table, user is asked, want
he/she overwrite the data. When yes, then the first (varRow1) and last
(varRow2) row with this date are found (data are always sorted by date),
and
the range between is deleted. After that new data are read into table and
table is sorted.



And if you're going to post the same message to multiple newsgroups,
please post
once and include all the newsgroups in your header. Crossposting is
fine.
Multiposting means that one of us wasted his time.

No multiposting of course. In other NG the posting was in german. :-)

Arvi Laanemets

--

Dave Peterson

--

Dave Peterson