Is there a formula that can display the Tab Name?  If not can a Macro?

Would anyone have a VBA function that copies everything that's on one
Excel workbook and paste just the values to another Excel workbook?  I
just want to copy the values and not the references.  It would be one
sheet to another sheet.

I am writing a program for my company that involves multiple workbooks
together.  One is teh actual output file that multiple users will
have.  One is file that has several spreadsheets of technical data
related to dimensions, weights and company specific info.  The other

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"
Thanks
Alec

I have a program where I loop throught the worksheets in a folder and copy
the information from a worksheet called "Print_Recap".
There are a few workbooks in the folder that don't have this sheet and I
simply want to skip them and go on to the next workbook.  The code i have

All,
I am moving the formatting (border, font, cell size, etc) from a cell on one
sheet to a cell on another sheet by using copy and PasteSpecial.  It works
fine except there are is a cell that does not get the borders copied.  It

The cells in in my spreadsheet contain a string like this:
AAA#####.##. I need to search the AA portion and the .## portion of
the string for any results where both are true. Ultimately, I'd like
to search for multiple .## entries (AAA and .01 or .02 or .03...).

I've been looking all over and I know it's possible,  but I can't seem to
figure this one out.
I want Excel to display the Network name (windows logon ID) in a cell. I'd
like this to be a function, so I can do IF statements with it.

I would like to be able to use a value in a cell as the numeric reference to
a row in another column, to which to sum values in that column.
Eg.
If A5 = 7, sum values in cells D3 to D7.

I have the following code included in a macro:
   Sheets("Week XX").Copy After:=Sheets(ActiveWorkbook.Sheets.Count)
   Application.Goto Reference:="'Week XX (2)'!R3C3"
What I would like to do is rename the copied worksheet "'Week XX (2)!'" to:

hi, can someone tell me a procedure to delete #N/A from within a large
range?

Im sure ive done this before, but cant get it to work now!
I want to find the last column (ie start at IJ go left until find last
column with data in it. I then want to delete from IJ up to 1 + the last
column!

I recently added a userform to a workbook I'm working on. When
creating the code for the form, I accidently placed a loop in the
wrong place, causing an infinte loop where ESC wouldn't cancel the
process. I used CTRL+Break to end my process, but since then (could

Could someone explain me what the tempoaray parameter defines in:
myCommandBarPopup.Controls.Add(type, id, parameter, before, TEMPORARY)
as Office.CommandBarButton;
This is all the documentation I've found:

i am programming an excel worksheet in which i need a cell to me able to
display to me the current system date. That is anytime i access the file, the
cell should be able to pick the current date as at the day i am accessing it.
please help