I need to try and automate the updating of a spreadsheet as much as possible
and would like to do the following...  Does anyone know if this is possible?
Basically I have a workbook called 'Scorecard.xls' - it has worksheets named
after markets (e.g. UK, Austria etc) and I need to ...

I have vlookups and match functions pointing to a templated field
where the user types in the number.  After the user types in the ref
number the formulas still show #N/A.  The formulas will only update
for values once I use Text to Columns to change the field to General

I've got 500 workbooks, all formatted the same.  I want to copy 2
columns from each of the workbooks to a new workbook.  I'm not sure I
can have 1000 columns in Excel, but I can split the process into
groups.  Anyway, I was testing my code with a couple of files and it's

Hi I have a range that that starts at
$A$2 which is named "dataStart" and ends with
$A$10 which is named "DataEnd".
I want to create a named range using the defined names, e.g

Hey all,
Is there a way to change the name of the worksheet via VBA code? I
could do it using a recorded macro, but the extra step I need is to
automate the name change. In cell A6 I have a name which I'd like to

Hello clever Excel people,
I have tried various different formulas with no success. Basically I have a
row of values, lets say: 10,45,12,28,30. I need formula that I can enter into
conditional formatting so that if any of the values are less than 3 away from

I have a spreadsheet (MS Excel 2003) that is currently shared over a
network among many users. Currently, we have some columns protected
from editing. However, some of the user base who edit the sheet and
have the password tend to not protect the workbook again after they

I am changing Location Names in Column A by Row Number. Each Location in
Column A has a hyperlink to a worksheet. I am also changing the worksheet
name.
When I do this, the hyperlink breaks.

I have the following:
A1 : Amount  B1: Paid Upto C1: Payment Term D1: Due Amount
By using a formula i want to get the due amount in D1 Due Amount
eg:

This works well everytime I open a file and hence an instance of Excel
opens.  However, if I first open a small file such that my
personal.xls file switches calculation to automatic, then if I open a
very big file, Excel automatically starts to calculate the file & only

I need to be able to delete entire rows that have no shading and keep
those that have a specific colouring. Any help would be appreciated.
Regards,
Vipul

Good morning all, hoping someone can assist with the following:
I'm effectively looking for a method to delete individual subs from within a
module.
3 subs, A, B & C in a single module.

How can I test in VBA if the selected range is a single cell or multiple
cells or multiple range of cells?
Many thanks
Cheers

This is probably a dumb question but I am having some trouble when importing
data into excel. Excel seems to be taking my data and formatting it
automatically. For example I have a field that asks how many users were
affected. Excel will take the answer of 1-10 and interpret it ...

Hi, does anyone know how I would wrap an xll file so I can consume it in an
automated process, i.e. without having excel installed or open? Ideally it
would be a technique that would allow me to call from .net.