I am trying to return the sum of a range using a function "CriteriaScore".
Iam tryin to use the Cells object to specify the Range, but VB is not happy.
If I define the function as follows, it works fine:
Function CriteriaScore () As Integer

Is there a command line switch that will prevent Excel from opening multiple
instances of the application? I develop under excel and use an interface to a
thrid party middleware product. If the user opens multiple copies of Excel
then the middleware doesn't know which one to use ...

I have produced the following coding, but for the range which is
selected beforehand, it coding only covers some of the range, not all
of it?
any ideas? (Has to be with option explicit on)

Kindly help me on this. I have a function (VBA) which automatically runs the
mundane checks for data in a given sheet and runs a VLOOKUP on that sheet.
This is specific to the financial model that I am building. But, the only
concern here is that, it doesnot recognise the value ...

Hi, I have tried a search but could not find what I am looking for.
I have a spreadsheet and would like to be able to move rows up and down
at the press of a button, so if I wanted to move row 20  to row 19,
highlighting a cell in row 20 and then a click of a button would swap

I'm trying to select a range and name it but i just cant do it
The range isn't always the same, it can start in R5C1 and ends at R27C76, or
R7C1 to R150C12.
Range("A1").Select

I need help. I am trying to write my first VBA code. First complicatio
has already occured :-).
I want to name the list after cell, including cell´s forma
(00"/"0000"/"00)

Hopefully an easy question to answer.
I have written a macro that adds a button and renames it. Below is the code:
ActiveSheet.Buttons.Add(2, 2, 100, 50).Select
ActiveSheet.Shapes("Button 1").Select

in my code I need to look at a worksheet's column A and find the
occurance of a particular string.
Column A IS sorted so the string will be togther.
for example,

I have a checkbox on a userform, and in a procedure I want to
make the checkbox invisible and
set it to false
Sub blob(x As CheckBox)

Below is the code thats supposed to take the given start and end date
and
list all the trading days in between (including the start and end
dates).

I have this situation:
A1 B1 C1 (the cells in a sheet)
value1 value2 formula
formula (in C1) is value1 - value2.

I have a word file which contains 100 pages. All the pages have name &
address of companies.(not in table) i have to transfer them to excel in
column format(for example first name, last name, address, phone etc)
can any one tell me code for this( i know how to open word & creat new

In my Excel application, I use the following code to get a table from my web
site:
Sub ReadWeb()
 Workbooks.OpenText FileName:="http://www.MYSITE.be/TestPHP/profsactual.xls"

I have some code that I want to be performed on all the closed workbooks in
sub-folders of a common parent, viz:
parent/childfolder1/workbook1.xls
parent/childfolder2/workbook2.xls