Good day folks,
I have this code:
termmon = Month(Sheets("Main").Cells(9, 3)) + 1
Range("J30").Select

I have a named range (non contiguous cells) going down several columns called
BidCatNum.  Most of these cells contain the letter "Y".  For each cell that
contains the letter "Y", I want to write code to perform an action on the
cell immediately to the right of it.

Hi
is there a way to check if a cell has spaces in it ?
If there is then can we remove the spaces.
for eg.

A friend helped me to set up some custom settings and toolbar sets on
Excel a few years ago.  These are automatically applied whenever Excel
2000 opens.  I would like to either remove these settings or edit them.
How can I do that?

Using the detail on the contextures website to overcome the limiations of
pivot tables, I came upon another issue as usual.  
To explain further, I have data that filled through an Oracle query.  The
range of data changes continuously, so I was using a dynamic range(using

Is it possible to create a vlookup that looks firsly down the second
column in a table to find the cell value but then brings back the value
from the 1st column?
Thanks, Tim

Excel 2003
I am exporting hyperlink data from Access to Excel.  I plan to use code from
Microsoft KB Article 271856 to turn the text in a specific Excel column back
into a working hyperlink.  

I need someway of allowing users to only paste in cell A1.  Now I can't
just create a user editable range and then protect the other cells as
the user will be pasting a table of data exported from an external
programming.  I just need the data to only be allowed to be pasted in

Hi People
Please can someone please tell me how I can include the facility to
open a file or save a file using an explorer based save as dialog box.
I can't seem to add an example image as there appears to be something

I have several rows of cells containing sentences, like 'the dog ra
after the cat). On another sheet, I have a glossary of terms wit
Column A giving the term, and column B the meaning (eg (Col A) Dog (Co
B) Four legged animal that dislikes cats).

all
I have a data like this
COlA         COlB         COlC         COLD         --------------------------
5-Jun    5-Jul    5-Aug    5-Sep    5-Oct    5-Nov    5-Dec    6-Jan

I have two worksheets containing 6 columns of data.  The data in the first
worksheets represents customer orders at a very detailed level.  The second
worksheet shows shipments on those orders at a much less detailed level.  The
columns in both worksheets contain data that when I ...

Can you create dynamic named ranges with dynamic number of rows, containing
the mega array formula written below? It should be created in a seperated
sheet if I add a values on a new row in a input sheet.
Problem causing the need:

hi
can any one help me in regard of matrix functions
i have to write some functions on matrix so i just wanna see how the
internal coding of mmult or minverse etc... i mean i want to know how an

This is a really easy one...
How do I start another macro from within another Macro?
Is this the best method?
Application.Run "testing.xls!DeleteBoldOtto"