Wonder if somone can help me please.
I have a spreadsheet with a number of cells that are blank to look at but
have a space in them as the first character.
Can someone tell me please how to write a macro that within a given range

Can I store the result of unique value by using advanced filter in VBA?
 Sheets(mysheet).Range(myR).AdvancedFilter Action:=xlFilterCopy,
CriteriaRange:=Sheets(mysheet).Range( _
       myR), CopyToRange:=Sheets(mysheet).Range("S5"), Unique:=True

Does anyone know how to register MSCAL.OCX using macro instructions?

I've created a custom function in Excel 2003 to meet a need that's too
complicated to be feasible in a formula.  When I initially create the formula
that references my function, the cell containing the formula calculates
correctly.  However, when the underlying data changes, the ...

I have data in a table in multiple worksheets... I would like to consolidate
the distinct data from these sheets into a single sheet....
eg. sheet1- A-B-C
sheet2 - X-Y-Z

I want to have a control on a UserForm (scollbar, slider, other
suggestions) in which the user can select the number of decimal places
(1 through 9) or significant digits (-1 through -9) for a range of
cells.  The siginficant digits is easy:

Could anyone tell me how you can save a file with a date one day before
today's date but if it falls on a holiday to save it with the prior date.
Thank you.

Am pulling data from a company db via SQL and the hard line breaks in
several fields are coming is as that annoying little rectangle.  Result is
that the report is pages and pages longer than it has to be.  When try to use
the Replace function, Excel does not recognize the ...

I have seen several close solutions...here is what I am trying to do:
Sheet "HOME" has a range from e9:e24  When user enters in cell e9 that entry
is linked to cell c6 on another sheet.  I want that sheet to be renamed to
that entry.  I used anothers code to have it work, however, ...

Just an offering to the world...a while back I had to remove all the
external references from all my range names in the active workbook, which is
something Name Manager does not do.  This code worked for me, but I make no
guarantees that it will do anything for anyone else.

I have a worksheet that I need to add to about a 100 excel workbooks
under a folder with the same structure and format.
So, I used Ron's code (Thanks!) to copy the worksheet to all the files
under that directory. However, I need to copied worksheet to have the

I have the following code in my worksheet that word wraps merged cells.  It
wraps the cell contents fine after a user types in the cells and clicks
enter.  The problem is that it then protects the cells, so then a user cannot
edit the contents in the cells because they are ...

Since my previous tests failed - the file paths werent entered into the
spreadsheet correctly!!  I wondered if it were possible to have excel
extract a list of all the files in a drive and put each file found's
full path location in a row on the spreadsheet.

I have an Excel 'Data' sheet that gets data from Access query (Data>>Import
Data>>New db query, then feeds data into 'Model' sheet that setup with
multiple formulas for analysis. Everything thus far works fine. I just need
to set up a macro to refresh the 'Data' sheet every time ...

I need to Find and Replace text in excel, however I'm bumping into a
problem: parts of longer words are being found by shorter words and these
parts are being then replace with the ReplaceWith text.
Word's VBA has the "MatchWholeWord Property" that avoids this problem.