is it possible to use the dcount function with vba?
i tried Application.WorksheetFunction.DCount(....) but didnt work,
sayid it could not get the DCount function.
thanks in advance,

Hi, I have a web query that pulls football league fixtures from a
website, the two teams appear in one cell after the extract, is there a
way of spliting the two team to individual cell.
This is what its looks like when extracted.

I am creating a spreadsheet using matrices that allows you to add
pre-defined transformations to a triangle. I have a problem with
circular references because my macros have to copy and paste a lot of
calculations. for example the 'current coordinates of image' is a

I have some formulas set up in a spreadsheet that other people will fill
progressively. In cells where the formula has no feeder' data to provide a
result it displays 1".
Cell A1=  1(month from B1) correct

I will be grateful if I can receive help regarding this problem:
I am trying to build an invoice workbook for my clinic. I have 2
problems:
1. I have almost 25 different procedures and 4 different room

Hi group,
How do I delete multiple hyperlinks and retain the text. At present I am
right clicking each hyperlink and going to remove hyperlink which is
painstakingly slow. Any help would be much appreciated.

If the cell contains..., do something
Hi.
1)
How to do the following:

hello XLers
I have a general question about best practice in Excel .  My workbook has
about 40 sheets.  On each sheet, there is a very lengthy formula dragged
over a range of about 120 cells.  Everything works fine, but it occurs to me

I am trying to compare two parts lists to each other to determine if there
are matches within the data.  If that data matches i would like to return the
part number and description from different cells  of the parts that matched.  
In addition to finding the ones that match is ...

I have created data ranges in a particular worksheet.  There are
formulas calculating those data ranges, but when the data is sorted a
different way, it obviously affects my formulas.  Is there a way to
"lock" in those ranges, and have the ranges move with the sorted cells?

I need a way to select the appropriate commission rate based on the
number of units sold.
My table looks something like this:
Min            Max          Rate

if the sum of row A8:J8 is greater than zero show the result in K8,
however if the sum is less than zero show a blank in K8.
Your assistance is appreciated.
Robert

Under the data menu there is no option for XML.  I just bought this computer
last week and I have some sort of 90 trial period of Microsoft office on
here.  I have a school project to do and I need to use the XML function, what
should I do? Is there anything that I can do?

I'm sorry but I am real newbie to Excel, I'm running a Sweet 16 pool at work
and wondered if I could use Excel to make a interactive score list? What I
want to do is list the players names in column A 1st , 2nd, 3rd and final
round totals in columns C, D, E and F and then have ...

I have 3 workbooks, each contains the same 30 tabs, but each workbook
contains different information.  There is a main workbook, and two extra with
information that I need to put all together on the main workbook.   I am
looking for the easiest way to paste the info from the 2 ...