I need to be able to protect a range of cells on a worksheet. These cells
have formulas in them, which will return a value based on what is entered in
a particular cell.  For example, if I enter the number 2 in cell A1, then A2
automatically displays "NEEDS ASSISTANCE"

How would I write a macro that would split up an addrss by spaces? Lets say
the address is 1364 W elm street apt #4? I am new to coding so I dont know
where to start. Also I need the macro to run down the list until there is no
address to move.

with a very good code from Ron DEBRUIN, i'm able to copy a list of mail in a
BCC but if it works with Excel 2000, i have a problem with Excel 2003 and a
message appears.
This is a copy screen from my code, can you help me.

I was wondering though if there is a way to show the complete Format Cells
dialog with all tabs using an xlBuiltInDialog?  I would like to override the
menu event for the Format Cells menu button, so that I can run code to
refresh some controls after a user changes their cell ...

I have several functions that are created and stored in an addin.  I can use
all these functions as they were designed, except, from within VBA code for
this worksheet.  
I have declared the function in the addin as public but i cannot seem to be

i have written follwing code
Private Sub CommandButton1_Click()
Dim rng As Range
Set rng = ActiveSheet.Range("g:g")

I have a workbook containing 5 imported tables that i want to refresh
every hour at 20 minutes past the hour.
The below code will only refresh them once at 20 minutes past.
Plese can you help me adapt this code to keep refreshing tem every hour

I want a macro that will display the box that allows you to choose a file and
the open it.
When I record the macro I get:
Workbooks.Open Filename:= _

Hi! I am trying to make a chart. I cannot refer directly to the cells since
the contents and plecment in spreadsheet is variable. I have 2 problems. 1)
When choosing the area from which get data for the chart I select cells in
the wrong worksheet. when trying to add a reference ...

I would like to find code that would take a variable out of filenames in a
specific location.
For example, here are my file names:
"G:\A F S\Monthly Reports\HiPath\CS\MonthlyC_AgtSum_060206_142704.dlt"

I wish for this macro to hide every rows whch contains "info" in colum
B, but when I push the button associated with it, all rows become
hidden. Any1 can help me with this?
ActiveSheet.Columns("B").Select

Hi...
I have 3000 files in a folder. Each file is numbered. Is there any code that
I can use to list these file names in a descending column, 1 number in each
cell? Sounds easy but its my headache for the week. Anyone goyt an asprin of

I have a Linked worksheet that I am saving as a new Workbook.  When I
open the new Workbook it ask me if I want to update the workbook.  Can
i automatically say "No".
I looked in the help file but I am still confused.

I am beginningt o embrace pivot charts for faster automated reports. Problem-
when you refresh pivots or data the chart wipes my colors and most important
the dtata point values.
So I must run through massive reports fixing many charts.

Question, is there a way that I can "compact" an excel sheet, just like
access can be compacted. Reason is that I have this workbook with about
35worksheets, all pivot tables, I had to change the datasource to sql and now
the size of the sheet jumped to 500megs (it started off ...