Is there a way to select a range of cells ONLY if they have data in them
while creating a graph macro.  Here is the code I have as of right now:
Sub Try1()
   Sheets("Raw Data").Select

I have an easy question which I could solve so far.
I would like to find all ? character on a worksheet and delete it from each
cells.
My code is:

How can I format the following please :-
     Worksheets("Test").Select
     With ActiveCell
       .Offset(1, 0).Value = cmb & " If " & pik <--- Format Right

Is it possible to import data into excel from web-site.
I refer to a web-site to get data and do some analysis. This is regarding
share market data. I have got the URL of the web site which is as follow:
http://www.nse-india.com/content/equities/eq_scriphistdata.htm

Frequently I have text in various cells in Excel.  For instance, A1,
A2, A3 might have text only in these cell.  There might be a different
sentence in each cell.  I would like to cut the text from A2 and A3 in
that order and append it to the text in A1 without doing cuts and

Does somebody know how to get vba codes (macros) from Excel files without
Excel installed in the machine? We're developing a important project and we
need a function (to call in .net) that only returns a string with the vba
code of an Excel file. Is there any way or component to ...

how to apply this matric in vba by replacing
O11:O17 by Myarray_1
p11:p17 by Myarray_2
q11:q17 by Myarray_3

Here is my worksheet:
a         b           c           d
1   contract                amount
2     m-7-001                1,000

But not by doing an for i = lbound(x()) to ubound(x()) and counter?
Thanks
Peter

Don't if I am blind or just can't see. Something has happened and the
valadtrion is not acting as it did. I moved the paste to see if that was it
get error
.Add Type:=xlValidateTextLength, AlertStyle:=xlValidAlertStop, _

Why should the following (supposedly simple piece of) code run so slowly:-
Private Sub Worksheet_Change(ByVal Target As Range)
   Application.ScreenUpdating = False
   Application.EnableEvents = False

thank you...bows down...

Anyone know if it's possible to toggle the Design Mode (on the Control
Toolbox) through code?
Thanks
BIG_J

OK I'm not even sure how to ask this:
I am in the printing industry and I would like to be able to keep a running
count on how many of each different type of stock I run. In column A I have
the code for a certain stock and in column B i have how many we ran. Column C

We have a form that we show non-modal. I've been asked to make it an
inactive window, like what happens if you click on a cell behind it.
The worksheet's activate method doesn't do it, and the range activate
method doesn't do it either.