Each day I create a new worksheet which shows the differences for the
prior business day on 4 accounts.  I would like to be able to see the
aggregate differences for the past 30 business days on each account.
To make it simple I post a simplified version of this here.  "Data

I have a spreadsheet with 16 columns.  Column C has text in each
cell.  In some of the cells in column C there is an (asterisk) * with
the text.  For example CARS *.  I would like in each instance of the
asterisk in column C to bold that entire row.  Then move on to the

In a module vbe i have a macro in which  i can't use the F8.
Seems deactivated.
Any idea?

Quick question.  I need to check if there are any numeric values in
column "J" if not I allow a refresh of data.  Is it possible to sum
column "J" and place the results in a variable using VB code or is
there an easier way to detect if there are numeric values in column

I have a Tabe of Contents bookmarked on Page 2 titled Table_Of_Contents
Can someone help me on the VBA code. I have the following written but it
says that the bookmark does not exist.
Private Sub CommandButton1_Click()

Example:
Sheet"xyz"
A    B    C    D    E    F    G   H    I
                  r                  x

I have forgotten my password to my Vba
is there away to get it , or something like that
regards
alvin

I have a pivot table showing data over 4 months.  Is it possible to set the
pivot table to only show those lines where the 'Grand Total' is greater than
1 ?

I am trying to have one main work book that I can:
-(1) Input data
-(2) Have that data exported to a closed excel workbook that modifies it and
-(3) returns it to the first workbook.

Is there any way to be notified when the Excel application is
activated, after some other application was the active application?
I've enabled the Excel application-level events, but none of them fire
when the Excel application is activated.

I need to pick a file (including the path), I have:
Sub pickOne()
s = Application.GetOpenFilename
MsgBox (s)

I'm looking to save a file as a text delimted file. I have a bit of code
that reads like so:
   ActiveWorkbook.SaveAs Filename:= _
       "S:\SUPPORT\CADTAR\CMS\!Exported_Text_Files!\dMR.txt",

We have created a large number of workbooks containing worksheets that are
protected, except for a few cells, all with the same password.  Is there any
way to remove protection from multiple worksheets at one time?  We are trying
to avoid having to open each worksheet at a time, ...

I have three sheets named 700, 800, 900 and other duplicate sheets named
A700, A800, A900, B700, B800, B900, etc. where 700 and A700 or B700 have the
duplicate information. Each day, I will go in sheet 700, 800 and 900 to hide
the rows that are completed (vary everyday).

I am working on a document that calculates indices based on a set of default
weightings. I want to allow the user to redistribute these weights without
changing the default information. It is set up so that the user can make
alterations in the cells that have a yellow background. ...