I've just learned how to do macros in a class and am hoping to apply it to
something at work.
We have a workbook (with MANY spreadsheets) that reflect billing.  The main
sheet is updated each month - Column H has January info and Column I will

I have a column containing 2500 items that have  hyperlinks. I would
like to set up another column that will show the hyperlink values. I
know this should be easy but I can't figure it out. Any suggestions?

I need to calculate the number of Accidents Per Million miles traveled.
I have a spreadsheet "Mileage" that has total miles per month in
columns:
1,047,178 1,014,900 1,050,481 1,049,958 948,471

I have a macro in a workbook that I would like to copy to another workbook
using a macro.  The following is the code that creates the new workbook and
worksheet.  
Sub AllocationView()

I am writing code for multiple checkboxes.  When each one is selected i
grabs a value for a certain cell from another worksheet.  I am pastin
the code below.  Can someone help me to write a function (I am kind o
new to writing functions) that would take care of this in much mor

Hello everyone... I'm new to making macros and would appreciate any hel
given for the questions / problems below.
In one worksheet (the only worksheet so far created), I have man
columns with different data.  One column is called School, anothe

I need a function that, given a range (single cell) as an argument, will
determine if the cell has been conditionally formatted with EquationIs and,
if yes, return the first formula as a text string.  I tried:
Function mnb(r As Range) As String

Hi -
Does anyone know, is there any way to trap a select or activate event for a
cell in a worksheet ?  My code generates statistical analysis on columns of
data and it would be nice to be able to highlight the source data involved

I want to be able to use a recordset that I get through ADO three
times, but it doesn't work like I want it to.  The obvious reason is
that I don't want to call the same procedure 3 times, becoz then it
takes 3 times as long of course.  Reusing the recordset means a 3 times

Is it possible to have a function on a cmdbutton in a userform t
show/hide sheet tabs??
Thanks all
--

The below piece of VB prints out a print area on my worksheet OK where
the print area varies in length.
Sub Button4_Click()
cc = 26

I'm trying to do a 'check' formula.  There is a column of data I want to
report on in a separate cell.  In the case where all the data is the
same....say each cell in the column contains "1", is there an if-then formula
that I can use to get:

I have a xml document, and one of it's values is a number in the format
1,5. And i need to insert in a excel cell that value * an integer, the
problem is that when i convert 1,5 to double i got 15 instead of 1.5. I
tried modifying the format of the number to 1.5 or replacing the , ...

I am new to VBA and was wondering if anyone could please help me with a
problem I have been encountering.
I am making a spreadsheet for my school's drama festival.It has a small
VBA program in it which shows the user a seating plan, which is placed

Hello I have a small problem searching for a value then getting the
value in the next column. If "spontaneous" is in the cell then I'd
prefer the next column's (B) cell to be 1 instead of the word in column
A being replaced with 1 (e.g. c.Value="1").