I am looking for either a macro or a function that will return a certain value.
ie:                      % With in Limits
test            100     99        98        97      96        .......
1                0.9     0.8       0.6       0.3     0.1

I'd like to know if it's possible to get a PopUpMenu with Flexgrid when
using
Excel 2002 ?
Regards,

I found the following code by Tom Oglivy on Google and have applied into my
app.
Just ran it for the first time and it is GREAT, except a second page is
being produced with just a reminent (the width of the top-right "X" box

built a new file and saved it in folder again when I try to access it gives a
5174 error code. File is in place and all correct. Rebuilt the file three
times and saved over still 5174 any ideas?
Thanks

This is a Sub and a Function.  I am relatively new to VBA scripting
for Excel 2003.  What I am trying to accomplish is this.
Have this FileSeach look into the path specified and it's sub-
directories, and then refer to the function and try to find all file

This may be kindda easy but for some reason I can't figure it out.
I have a Macro that formats multiple sheets within the same workbook.
Everything is working great but there is one last step I'd like to do and I'm
not certain on how to accomplish it.

Could anyone help me with code to search through the file names of workbooks
I already have open, and for each file that meets my search criteria make a
specific worksheet and range active?
Thanks

how do i disable the close button on my userform?
or can i just remove it?
and when the user clicks cancel... is there a way to direct the user back to
sheet1 ?

I am trying to connect to a SQL Server 2005 database using the connection
parameters listed below.  After connecting to the SQL Server 2005 database I
execute my sql statement.  But I always timeout after approximately 60
seconds.  I executed the sql statement within the query ...

How can VBA code which executes in under one second in Excel 2003 turn into a
marathon 62 seconds in Excel 2007?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

Are the last 2 statements equivalent?
  Dim oReportSheet As Worksheet
  oReportSheet = Worksheets.Add
  oReportSheet.Range(Cells(1, 1), Cells(1,

i got 5 columns A,B,C,D,E
Is there a code i can write for a macro to delete all 5 columns
im sure its something simple ;-)

I have  workbook which is updates very often daily and shared for users for
view. It meant for view only but I  have to prevent users from copying by
using ctrl+c or right click and save as option in their computer. How can I
do it in my workbook?

If I use a macro (and button) to go from the current active cell (currently
C50) to a chart which is on row 500 or so, how can I use code (macro &
button) to go back up to the next blank cell in column C?
There may be an easier way to do this but the summary is to click a button

I've a calculation in Excel VBA and it defaults to giving the result
up to 11 decimal places.  I need it to be accurate to 16 decimal
places.  Can this be done and if so how?
Here's the calculation: