Does Excel have a problem running a VBA code when the worksheet is
protected? If yes, is there a way to overcome it?
Thanks.

Looking for some assistance. built an Index Match that works great -
but I need to incorporate an IF statement based on varying levels of
revenue.
so here is the original formula:

Excel XP & Win XP
   I'm asking this question from a position of total ignorance.  My
question is:
How do I FAX with VBA code?

I am trying to access the value in a single cell that is a named range.
Code:
If Workbooks(Current).Names("UpDate_File_Name1").Value = "Save to" then
...

Excel 2003 VBA
I'm getting an error "next without for" in the following, simple code.
Doesn't make sense to me.  Any help?
Private Sub CommandButton3_Click()

My "A" column is the network.  Each cell in that column has the same
drop-down menu: NetworkA, NetworkB, etc.
My "B" column is the server name.
What I want is:

The following code takes many, many minutes to run on several hundred rows.  
Does anyone have any suggestions that might speed it up?
Thanks in advance!
Option Explicit

I have created a macro in vba to input a "string of numbers" into a
cell.
-Some of the numbers in the string have leading zeros so I have
formatted the cell type as "text."

Below loop works ok. But sheet ("pickuptime2") gets near over 15000
rows and it gets
slower.Any suggestions would be helpful. Thank you very much in
advance.

I have a project that seemed easy at first glance.  Simply stated, I
want to insert a cropped and sized .PNG image from a website into my
worksheet at a predetermined location.
It wasn't that easy (I'm new at VBA, so bear with me).  I started out

I have a workbook with lots of worksheets, but as part of my macro I
want to just save the sheet named data1 as a new file. Is there any
easy way that I can do this?
Thanks in advance,

I have a range of cells where the values are in time format mm:ss.000
Some of the cells will have values, some will be 00.00.000.
I need to either;
Empty all cells where the value is 00.00.000 (so a min formula on a

I am trying to write a harmonic mean function that will evaluate a set
of numbers, even if there are negative or zero values.
The harmonic mean formula is the count of numbers in the data set
divided by the sum of 1/n.  The excel function is =harmean().  For

I am trying to write a macro that filter about 5000 rows into the
different dates. After filtering the dates from Jan04 to Dec08 it then
copies the rows to a different sheet. After each date range is filtered
it then adds a row to add all costs together. I can do the filtering

I am creating a chart by ht following code,  that is activated via
command button.
Private Sub CommandButton3_Click()
   Application.ScreenUpdating = False