I have  a spreadsheet that has hyperlinks.  Everytime you click on a
link it starts a new session.  I want to be able to use the same
session so the user does not have to login everytime.  Does any one
know of how this is possible?

I'm trying to get a formula that will give me the % of specified
numbers that equal's less that 80%, in my spreadsheet I have numbers
that identify accounts in column B and in column C I have the
percentage's. I was able to figure out part of step 1 which was

Is there a way to manipulate a column without having to refer to it every
time?   For instance, can I somehow select the column by using M:M and then
reference the cell rows within that column of M?
Here is what I have:

i want a specific macro to run every few seconds, that will change the
caption of a label........
Can this be done........if so wat will the syntax be?
thanx in advance

Is there a way to create a dockable list of the sheets in an Excel
file?  I work with various Excel files that have numerous sheets with
long tab name and it is painful tabbing. Is the list that comes up on
righting clicking by the directional arrows dockable or vba coding

i get a runtime error '13' type mismatch when i run my code. can someone help
me with this code. the code basically opens a file, take info from the file
then close the file. when i click debug part of my code highlighted
"if FName <> False Then"

For example cell A1 contains a number eg 100
A2 contains either a number eg 110 or strings like Pk, Ok, NFT, NFT►
Formula  =IF(A2>0,A2,A1)
If cell = 0.001 I would like the rest of the formula to calculate from

in column J i have either True or False i want to search column J and if i
find True i want to change the coresponding cell in column A to Green any
ideas
thanks in advance

I am extending a DLL that we have written for Excel VBA to call.
One of the new functions has 21 arguments.  However, Excel
refuses to compile the VBA code and says that it cannot find
the function.  Is there a limit on the number of arguments for

I would like to know how can I write a VBA macro to execute the
following.
Given two strings of characters having the same length, I need a
function that compares each couple of characters in the same position

Hi guys I work in a school and they asked me to tell them which
students got the total full mark in all subjects, my problem is every
subject have its own excel workbook file, the students are sorted by
class then by IDs, from subject to subject the file may be different (I

I'm brand new to macros and coding in general.  I've sifted through this
site for an answer, but there was no one post to cover what I needed, so I
pieced this baby together from different posts.  
I will be getting these excel files frequently, and they can contain

I have a macro that Color codes all the empty cells in the Range and enters
the legend Missing! to show what attributes need to be entered.
Sub FillEmptyCells()
WCount = Worksheets.Count

I have a download from a generic program that sends dates as follows
20061230 and I need to automatically change the formating to read 30/12/2006
so that I can perform other calculations on the date, how can I do this?

I want to be able to drag and drop cells without holding down the control
key. Just want to click on the cell and drag the info to a different
location.....Any ideas.......