Hi, experts
Please, help me if you can.
Every time I change cell value on other worksheet than the one where
selfwritten function is called and if this cell rules any argument

I have got a bit of a problem i cannot seem to work out. I have got 3
coloums of data, column A has town names, say towna townb townc etc,
the same town name will be repeated within the column several times or
sometimes only once.  In coloum 3 is various data say data1, data2,

The new Excel 2007 is very good, all the possibilities to work with
big databases, the flexibility in pivot tables and filters is awesome.
However I am having a very big problem. When I am working with
autofilters I can't choose a category and fill the row of other column

I have
Numerous tank tables (tanks containing liquids) with columns, Sounding,
Volume, Centre of gravity, free surface etc
One summary table, to sum the contents from said tanks, with the same

I hv data sheet and make another summary sheet with one criteria. I can
write code, which is show you. Problem is that its do all column in my
summary report from data sheet ( column A6 to G6) but I wants selected column
(in my summary)like A,B,D,F only. please help me what i ...

I have a list of people names (approx 20) that I would like to use to name
separate tabs in a spreadsheet.  For each person, I need two named tabs (one
has all the calculated data and the other has a graph of selected
information).  I need to set up a macro that automatically ...

This maybe a very simple question but I have created a calender in excel
using active X I was wondering how I would go about colouring in for example
every Wednesday of that month so they stand out I have looked in all the
properties and I haven't found a way

Hi all, Tom Hutchins helped me out with some code and i need to change
it.
The code loops through a folder and looks at the last time the file was
modified to open the latest file and i need to look at the date stamp

I have a addin used by several users. One of the sheet in addin is
used for recording data.
Now I have added some more functions and want to distribute the same
to users.

I have excel sheet and want to loop thought it contents and show the value
of the contents on a form. This the code I have and it just wont work and I
cant see why any help be great thanks?
Dim intshowrow As Integer

We have a spreadsheet used by multiple people from within MS Sharepoint.  
1st ... I'm looking for a way to generate a message that tells the user that
someone else is in the spreadsheet as soon as they open it. My current plan
is to tell them it's in use & to enter their data ...

Hi! Here is the code I am using...I don't understand why it's not
working. In ActiveCell.Offset(0, -1) I have a list of URLs. I need for
the results of the query to be dropped in the ActiveCell.Address. It
keeps crashing on me. It's complaining of the following...

I'm going around with this.  What am I doing wrong?
Option Explicit
Private ProRataShareCell As String
Private Sub Worksheet_Activate()

I have a couple of user forms including text boxes that I would like to use
to complete cells in a spreadsheet. I need to look for the next empty cell to
start the data in column a. I have this code working fine but is there a
simple way to increment the c.address by one column ...