This is a bit verbose but no debugging is required. Both macros work.
The problem is that each time I run the below ApplyFilter macro and then the
RemoveFilter macro, execution becomes progressively slower. It is only
apparent when there is a lot of data being filtered (which is ...

how to do web login for web project on Linux machine?. we are doing
small project, we have to login first and then only he can do any
opeartion, how to provide this login facility?. we are using
apache--php--sql. thanks.

Can someone kindly sell me the trick to call up subroutines (residing in
a general module) to a Class Module.-ie I want to make the call while in
the Class Module.
My cumbersome workaround is to duplicate and paste a copy of the

I am a geomatics student and would like to use excel for calculating
horizontal curves but, there is no formula for converting from degrees to
degrees-minutes-seconds.  If there is could you please tell me where to get
it.

is it possible to check the case of a letter. All the functions i found in
help seem to be able to convert text to a particular case but not check the
case

Have Googled, helped and Microsofted, No joy.
Is there such a thing as list of the expressions used for the "Environ"
function?
IE:

How do I write a macro that can be used in all workbooks and can I assign it
to a button?

Any help is greatly appreciated.
I am using the following snippet in code to protect locked cells and allow
the user to only select unlocked cells.
       .Protect userinterfaceonly:=True

I have a work book with multiple sheets.  I want the user to be able to
select sheet 1 to access macro buttons.  I want them to be able to view the
results of the macro data entries on sheet 2, but I do not want them to be
able to directly modify or even select sheet 2, only view ...

is it possible to check the format of a time value (like hh:mm) without
having to use regular expressions. the numberformat function doest seem to be
applicable to time

Can someone please expain...
I have a form that, when loaded, initialises a "Worksheet" variable to
point to a certain worksheet...
In the general declarations section:

I have a workbook with one worksheet in it that I use as a template to
create a new sheet for each of my sales managers.  In *ThisWorkbook*
(in my template) I have some coding.  It's on the workbook level and
does a few various things such as; depending on which cell they have

Hello from Steved
I've got a problem and that is when I insert a Row My ranges Set myRng =
Me.Range("A10:A10") will not change ie to Set myRng = Me.Range("A11:A11"),
Is their something I can do as now I've got to go and change every range by 1.

I need to write write a program that will cut a line of information and paste
it onto another page when prompted by the checking of a box. I have tried
this by creating macros and adding them to format check boxes but when the
computer is turned off something happens to them and ...

I am using the following code to find "0"in Column R, then select three cells
to the left and clear the contents in those cells.  This code performs the
operation, however, it gets stuck in the loop...Can anyone help.
Thanks