I have an excel workbook which has a lot of code written to automated
tasks. However the codes now need some housekeeping. The only problem
is the author is no longer with us and they have passworded the sheets
as well as the workbook as a whole. Is there anyway round this dilema,

I learnt this from the previous post. However, do you have any idea to
create the dynamic named range that will cover some blank cells?
Thank you in advance.
Bobocat

One quick question:
I have tried to create a dynamic range using the standard formula:
=OFFSET($A$1,0,0,COUNT($A:$A),1)
However i get an error stating something is wrong in the formula. I

'Excel Problem
(http://www.generationtalk.com/talk/viewtopic.php?t=618)
Can anybody answer this query please?
because I dont seem to know the answe

I have a chart based on data in an xls sheet.
Both the x and y data data change when calculations are made.
So I don't want the x axis variable to be fixed, per se, but I'd like
the scale limit dialog to allow me to put in the cell on the sheet to

I have a spreadsheet with data imported from a database program.  One of the
columns is the zip code.  Some of the zip codes have zip-plus-4 and others
just have the old 5-digit zip code.  I want to be able to sort by the zip
code, meaning I'd end up with 5-digit zip codes ...

From a workbook I wanted a button that would copy a folder to another
drive. After dinging around I came up with this:
Set CpyFolder = CreateObject("Scripting.FileSystemObject")
CpyFolder.CopyFolder "c:\TestIt", "d:\TestIt", overwrite

Never had this before but how do I do it?
I have a range of cells say A1 to D10, I tried to copy the cel
contents to another sheet and while the cells controlled by macro
copied the info the ones controlled by formulas returned ####ref

How do I change my hyperlink to open with a  different web browser?
Thanks in advance.

Frequently my font size tool, percent tool, and currency tools on the
Formatting toolbar stops working. It has no action. Other times it
works.
Anyone know anything about this problem before I work to establishing a

I wrote last time:
I want to know what I will get paid TODAY, THIS WEEK or by the
MONTH.
I don't know how to get the Day (C2),Week (D2) and Month.(E2).

How can I create a formula that will do this: = IF cell A2 ="m" and if cell
D2 is between 5/19/06 and 6/20/06 than cell E2 ="June" + if A2 = "m" and D2
is between 6/21/06 and 7/18/06 than E2 = "July" and so on?
This is the formula I used:

I CALCULATE INTREST CALCULATION IN INDIAN CURRENCY
PL SEND ME MY ID

I have a password-protected worksheet that uses several add-ins many
people don't have.  Is there a way to export my worksheet to a
standalone executable file that people could run even if they don't
have Excel or my add-ins?

How can I count the number of caracters including spaces in a microsoft excel
worksheet