I have two worksheets on one workbook. One named 'main page', the other
one is 'template page' which includes some table template inside. In
the main page, based on diifferent option button choice, different
table template in 'template page' will be copyed into main page.

I would like to find the max value in a specific range of multi-worksheets in
a workbook.
I try to select the range of mult-worksheets but I am not able to get the
max value for below coding, please advise me what's the problem and how to

I am having a problem getting this to work and would appreciate your input.
In "Module1":
Function SetBackgroundColor(Parameter As Range) As String
Dim xlRange As Range

I've found a couple of posts similar to what i need, but i'm still having
issues with it. i'm trying to insert a formula into a cell via VB, and i'm
not doing the quotations correct i think. i just went ahead and put the
generic formula in there with no extra messy quotation ...

I need to fetch data from excel page (file.xls) programatically, from a c++
program.
Can someone direct me please?
Thanks in advance.

I have two headaches, 1. i have searched a large data base and found the
address of the values I want to add to my chart. If my starting address
is Strt1 and ends Ends1, I would like to pass these variables because
unlike the code below I do not know where they might be.

I have a spreadsheet the 10,612 DOB's in the yyyymmdd format as required by
Federal Law Enforcement.  Those dates need to be changed to mmddyyyy.

I'm having a problem with a form, I use a combo box to select values from,
but when I read the cell on the work sheet it refers to, it the cell is
empty it come up with an error. I thought that - Subsyst.AddItem ""   ,
would handle it but it doesn't, any help would be appreciated

I have an input from a data file, the field value for example is
2300000.
I need a string function to  insert a decimal point before the second
last 0.

I'm trying to add items into a listbox using the code:
Private Sub ListBox3_Click()
ListBox3.ColumnCount = 4
ListBox3.AddItem ("West")

When Excel opens a workbook, it checks whether it is currently already open,
and in this case opens the workbook in read-only mode. This is good as it
prevents writing conflicts.
However I noticed that Excel won't check that lock, when the file is an

Hello all, is it possible to add "insert time" and "insert date" to the
right click popup menu? I am trying to get away from keyboard
shortcuts.
TIA

I need to write a coding to identified the specified row is stated
Completed or Not Completed, If Completed the selected row will cut and
paste to Completed Task (Next Sheet), Not Completed will move down to
bottom.

bgeier did a lot to this code, it works perfectly now except for that the
comments don't add to an existing comment, they seem to be overwriting the
existing comment.  Please help, this code will be used in a major application
for my company but cannot be used if I cannot get it ...

hey i need help developing a program that when you open it, you will be asked
a certain yes or no question and based on that answer, you will be asked
another question (yes or no) and so on..., allowing you in the end to be able
to recognize , for example, which papers need to be ...