Sorry for taking so long to get back to you. Recording macro's is great to
start to get a handle on the syntax but they are a long way from perfect. To
take your code to the next level you want to get a handle on workbook,
worksheet and range objects. Once you figure these out your code will
drastically improve. It looks like you are already getting a start in that
direction. I can not stress this enough though DECLARE ALL OF YOUR VARIABLES.
This will help to ensure that your code is efficient and with the
intiellisence you will see the properties and methods of the objects.
--
HTH...

Jim Thomlinson


"dircur" wrote:


I posted late last night and only just now got to work to see your
responses. I think Jims set range method is what I will try first as I
am pretty sure it has something to do with selecting from a different
sheet. I am sure I will get what I need from it but can already see my
next bug. I'll let you know if the range select for applying the data
filter fails.
Does anyone know of a resource that explains the errors?
In my quest for insight on this I found a lot of people getting the
same errors doing some form of a selection. I think if I uderstood the
errror I would better understand why it failed. Meaning I would
understand when it is appropriat and when it is not. I think its
obvious a lot of my code is clipped from recorded macros. These tend to
fail to give you the results you really want. Anyway Thanks Jim I will
repost to say it is solved as soon as I can.


--
dircur
------------------------------------------------------------------------
dircur's Profile: http://www.excelforum.com/member.php...o&userid=31393
View this thread: http://www.excelforum.com/showthread...hreadid=510910