Hello, Experts,
I wanted to make array formula in multiple cells with relative
references, such as:
In cell C1:  {=SUM(LEN(A1:A5))}

I'm having a problem getting the correct number of rows returned to me after
filtering.
I have the following lines in my Init Function.
ActiveSheet.AutoFilterMode = False

To all,
I've got a UDF, but Excel will only calc it when the cell containing it is
edited, ie, F2, enter.
How can I force a calc?  I tried 'Calculate' on the SheetActivate event, and

I am good with access new with Excel
What I want to do, in VBA, is search Column B and get the row number
for the first occurence of a value.  Let's say I am searching for a value of
"Fish" and "Fish" is in B1207.  I would just like the Function to give back

Is there away to chenge the default fill colour from yellow to a different
colour

Hi to all! I am new at programming/writing macros in Excel. I have a
spreadsheet imported from Access (Dept, Division, Status, Payment). I
know how to sub-total for each division.
I need to do the following:

I have a column of cells:
ABC-1--2.00---0786759021----33
JYP-1--0.76---0786759021----54
NUJ-1--112.30---0786759021----18

I have a workbook that I saved as a webpage.
It has 5 or 6 tabs in it.
Some of the tabs have a lot of data and take a bit to load.
I created a link to just one of the HTM pages to open just one tab but it

I retrieve data from a SQL database (AspenTech IP21) from within VBA.
No problem at all. But for those who know teh AspenTech database, know that
Aspentech realtime scans values and put them into the database.
In this database, there is running an algorithm that compresses these

I'm able to filter out lines which are complete duplicates of existing ones.
What I can't do is eliminate lines in which just one cell is duplicated.
For example, suppose I have two columns: email addresses and activities.
Someone has an email address alongside tennis and the same ...

Hi...
I have 3 columns A - C.
In Column A I have values 1 -15 in descending order.
In Column B I have names of tools.

I have created a web query to download table relating to a number of
companies.
Whenever I run the query I need to either type in the unique company
identifier or

Can you trigger a macro by changing 1 cell?
Specifically if I change Cell Y1 of worksheet January I want
SortModule.FRDSort  to run.

I have a userform with several textboxes. I do not want the
textboxes to show zero value. Is there an easy way to do this? Thanks.

Hello Excel users and experts,
For the life of me I cannot get this simple change event to fire.  I select
A2, make a change in it and hit Enter... nothing!  I've tried it in the
sheet module, the ThisWorkbook module and a regular module.  Still no go.  I