Here is the excel ws and the code follows.
        1/1/2005    start date    1/1/2005
            end date    2/2/2006
This code is supposed to copy the start date, then extract the next trading

Hello. I am working with an excel worksheet and i need the following:
1. A function that allows me to display the date when the file was last
modiffied.
2. A button that will open a save window at a predefinded path so that

Hello, has anyone come across this problem before..
I have some code which looks in each cell and hides the row if it meets
a certain criteria. If i run the code it works instantaneously but after
printing the worksheet (or print previewing it) the code takes ages.

I have written a VBA macro for an Excel 2003 workbook.  Amongst other things,
at the end of the month it is intended to copy the most recent monthly sheet
and add it as a fresh copy as the new month's sheet for editing.
The weird thing is that, although this works fine on my ...

I repost the message from "excel.worksheet.functions" forum, maybe it was
not appropriate for the questions I had (or maybe it was too complicated)...
-----------------
-----------------

Sub PrepDepsAndWiths()
Sheets("ImportWorkTable").Select
ActiveSheet.UsedRange.Offset(1, 0).Copy
Sheets("DepositsAndWithdrawals").Range("D2")

How do I get the Workbook name associated with a range?
Function whereisit(r As Range) As String
MsgBox (r.Address)
MsgBox (r.Worksheet.Name)

Is there a function that when called, the user allow to select a cel on
a woorksheet and that the function returns the selected worksheet and
the selected cel (x,y position)?
Tadashii

I have a running list of data in a worksheet2 where column B contains
the date of the data.
What I would like is a macro that will find the last line of data in
worksheet2, get the date in that last line column B and plant it on

OK, gang, help me out here, please.  I have researched several similar
threads that don't completely address the question.  I have seen
multiple responses that show how to make a cell's contents the Header,
e.g.:

I use some Excel VBA code repeatedly to extract data from text files, then
to paste into new Excel workbooks, created from a template.
Now the code has worked successfully in the past, and for my current
application is taking 45 seconds to run.

Sorry for my question,
but i must write a VBA macro in Excel to analize every second a
specified excel file A.
The excel file is always open.

I am wondering how to get a process, contained in Microsoft Excel, to repeat
itself.  I need to cut a reference number from sheet one, paste into sheet
two, and then print sheet two.  There are multiple reference numbers in sheet
one.  I don't know how to get the process to ...

I've opened Book1.xls (I'm in Sheet1's A1, say), and then I open another 50
or so other books from a single folder (at one go).  What I'm after is a
generic sub which can minimize all other windows (i.e. those from the 50+
other books except the ones for Book1.xls).  I will trigger ...

This code always gives me the error above. I have no idea what's wrong with
this
The point is to go through a list of dates and if they are less than say
1/1/2005 (my start date entered in the spreadsheet) change them  to 0 and