Excel 2003
In a VBA routine, I'm trying to do a simple countif.
If Application.WorksheetFunction _
  .CountIf(Range("a:a"),"010020") > 0 Then

Excel 2003 sp2
When in the VBE, I could click on a word in my code, hit F1, and my
help file would open to that subject (context sensative). Suddenly now
when I do that, only my Visual Basic Help task pane opens on the right

I tried to look around but it seems like I can't find the right answer
for my question.
I have a data group by a header & sub-header. See example below:
****************************

auto open xls file when opening .xll at the same time.

I cannot figure out the following text, some one could explain it?
xlAutoRegister
? xloper * __stdcall xlAutoRegister(xloper *);
This function is only called from Excel 4 macro sheets when an executing

I have numbers in column A from 1,2,3,4,5,..etc.
I need a macro that will find a number for example "3" and insert 4 rows
under the row that has the number "3" in column A.
Any help will be appreciated.

Hi all, i am using an inputbox to request a password, is it possible to
change the characters that are being typed in to a "*" or must one use a
form to have that function ??
Best regards,

I depend on the list properties/method tool in th editor to write code and I
can't understand why it sometimes works and other times not. EG. if  I type
Range("A1").
the properties/method tool is shown. If I enter

Can anyone please tell me how to run a macro automatically from the
VB-editor when opening the spreadsheet ?
Br,
Jakob

The following code I recorded to import data from a closed workbook
("lala.xls") into the active sheet.
As I'm trying to import data from multiple closed workbooks, I need to
make the filename "lala.xls" and its folder path, variables.

I am having a problem where I paste the contents of an array in a range of
cells on a spreadsheet.
Where the value in the array is nil or blank and i paste it into the range
of cells, instead of blank cells I am getting the values inherited from the

in Excel97, and in Excel2007

I need to extract all numbers into different columns (delimiter is ,). e.g.
1,325,16420,5,6,120,4643,2,8,-71,-68,-6     the length of numbers within
could vary.

I have a vba application I'm working on that creates numerous worksheets
within a workbook.  I need to save off a copy of specific worksheets from the
workbook to their own file name.  The object model appears to support that by
using the saveas method with a worksheet object ...

I am using the following command to direct what happens in column of cells:
=IF(A6=1, E6*D3, IF(A6=2, E6*E3))
This works fine for 2 options, but when I try to add a 3rd & 4th, I get an
error.