Is anybody else experiencing huge delys with the the .Clear method?
and more importantly, are there any magical tips for it?
Let's take an example:      Range("Sheet2!C10:C40000").Clear
takes 1minute 54 seconds(yes, i timed it with a stopwatch). This is an

Hi! I have a very easy sub that I use in many worksheets. I use the sub like
this: I select certain cells and then I press Alt+F8. The sub then removes
blanks that are used as thousand separators (1 000 000 becomes 1000000) so
that Excel can read the values as numbers and not as ...

Hi! I have a macro that shows in a messagebox who used the most recent user
of a file is. It runs when the workbook is opened. Now I want to show who and
when saved the file the last time. How do I do that? Thanks!
Sub Auto_Open()

I am building an excel application which draws it's information from another
workbook called "NSRDB.xlsx.  I need to find some code to include in some of
the macros, which checks if NSRDB.xlsx is already open by other users on our
network. I used to use the following:

I am having difficulty controlling worksheet recalculation within a
VBA macro when the worksheet contains a reference to a volatile
function, namely RAND().
The following is a contrived example scaled down to the bare bones.

Hello all, i got a reply on my last post but it is not doing what i
require. What i need to do is the following: if i click on a specific
cell(named range "Hood") and if it is more than zero then i want to go
to another sheet and show the applicable parts.

Is there any idea to draw an arrow at form using word macro?

I saw another post dated Nov 2004 where Dave Peterson discussed using
a global variable to overcome the problem. Refer
http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/b9bee
fad029c9e9c/946b03f15071c036?lnk=gst&q=macro+jumps#946b03f15071c036
I have ...

I have a spreadsheet with a worksheet that I would like to create a CSV file
from the worksheet.  I would like to copy all columns data from A to L to the
CSV file, only the records where date (Column D) greater than today, and not
include hidden columns H and I.  The first ...

I have recorded a macro but unfortunately it only works for one column.  I
would like it to apply to any column and be dependent on what is the active
cell.  How do i change this code to do that?
I'm not sure what the field = 24 stands for and what I can replace it with

Please help me modify the script listed below to add the column names listed
beow to the first row in the test.csv file.  These column names are different
from the input worksheet.
Please help me complete this task.

Hi Reader
How to get Properties Generate tab "Location" value  ?
What location is file saved directory.
Below coding just return file name only.

I have a sheet with a range A6:BP6 and I want to be able to sort by column
after a message prompt to select the column to sort by. Is this possible?
I have tried autofilter and it and found I needed to unlock the workbook
before accessing this feature, furthermore, for some reason ...

I have a range(thisRange) that I would like to populate the first column
with dates from January 1 to december 31 of an x year
Sub populateDate(yr as string)
   Dim Myyear as date

I am trying to write some code to protect all of the selected sheets.  I
kept getting an application error in the code below until I added the
objSheet.Select line prior to the .Protect line.  Why does it not work
unless I select the sheet first?