I have problems with TreeView controls on a worksheet: on reopening the
workbook, they resize the scrollable area; and on saving or closing the
workbook, Excel crashes.
I could use the treeviews on a form, but they are more useful on the sheet,

I have a file index, which inputs the paths in various columns for
Autofiltering and makes the files into hyperlinks. It takes a while to
process (22 rows takes approx 2 mins to process). There will be more files
added as work proceeds. I want to know if there is a way to speed ...

Can someone advice me how to modify the following code to copy a line
from column A:U instead of the whole line?
Dim iLastRow As Long, iNextRow As Long
    Dim i As Long

Hi, I'm a beginner for Excel VBA.
What I want to do is to take out the first 15 characters in column C,
and copy the rest to clumn A. I have the following code, but VBA don't
recognize substitute funciton. Help....

We have a pricing add-in that several of our pricing models use. For most
workbooks the functions simply sit in cells. In one the VBA also calls the
functions. So for that one I set up a Reference. The problem is this
spreadsheet can get large, and when the user opens more than one ...

Could someone please help me with the following for Excel 2003?
I am trying to modify the following code shown below:
My worksheet is named: DPC Expenses. I wish to create a macro filter
that prompts the user for the following:

I've come across a problem that has stumped me and now I'm ready to
pull my hair out.
I query a website for a file each day (or various dates).   I have no
problem getting the CSV file off the website and importing it into

I'm using the Worksheet_Calculate code but unfortunately, the Undo icon
is grayed out indefinitely.  Any workaround to preserve the Undo
function while keeping my Worksheet_Calculate code?  
Please help.

I'm finishing up a macro and need to store the name of the macro in a
variable.
I want the macro to find out what worksheet the user is on, execute the
program which in this case is a webquery (which runs on a specific

I have a rather extensive excel file (131 pages and 4MB) that it used by 80
different users each in a remote location.  I'm trying to make some updates
to the file without copying over each users copy of the file.  I thought
about writing a macro/code to make changes to the ...

I have 1 workbook with sheet1 named Found containing column headings of phone
number, First Name, Last Name, ID , Building, Floor, etc.  Sheet2 is named
Not Found
This Found will have a list of phone numbers populated already.

I think this should be easy, but I can't figure it out. Would like
code to average a continuous column that varies in number of cells
from month to month. I am try to show an avg on top of the column of
active cells?  Thanks  RM

Hi Group.
I got good help earlier, so once again I ask for help.
I recorded a macro, where in the query I set DebKart.Sælger = 1
and it worked.

Current Code:
ActiveSheet.PasteSpecial Format:=3
This is somebody else's code.
Just a quick question about the Format:=3

Any idea how to set a timer in VBA (start it when a UserForm
opens, respond to timer events while form is open, cancel when form closes)?