There it is again:
This one to hide rows with "info" in column B:
Dim cell As Range
For Each cell In Range("B:B")

I found code in the archives that works in that it requests a number and
then inputs that number into a cell.  However, it doesn't have a cancel and
I haven't had luck getting anything to work for that.  Since this code isn't
specifically for this simple purpose even though I was ...

I am using an array to pass variables to a User Form as follows (with Array
indices hard coded at the moment).
Array data as follows;
   ChartSourceSheets(1, 1) = "SynchroELEVATIONSYNCHROTELLBACK"            

I am counting the rows in a selected column using the following code which is
working fine.  However, I would like to modify this to count the rows where
the value <> 0.
Please help

What are some commands to insert a row with VBA
--
Tar
-----------------------------------------------------------------------

Hi I am trying to create a sequential number generator in a workbook so that
each time it is accessed the next open cell will autofill with the next
higher number. I need it to do this from 150 to 10,000. I've tried to create
a couple macros, don't know much about pivot tables.

I'm currently working on a programme with excel 2003 (communicates with
word...)
Now it has 8 modules and 1 user form (with 576 controls, pretty
big...), totally 161K after exporting.

Hi all, is there a way of capturing either the User name or Machine name
that the workbook is being opened on?, i would like to send a workbook
to some people but do not want to allow them to open the workbook on
any other machine than their own so if their machine is called Office1

I just got an unbelievable behavior from excel when i did the following
value copying:
-----------------------------
Sub mycopy()

i have two listboxes containing values. i need to multiply these two values
and display the answer in a text box. but am unsure on how to do so!
can anyone help please?
thanks

I was wondering if it is ever possible to make combinations in excel or
access or any other software based on my criteria.
Total number I have starts from 1 to 85. I want to count and list all
possible combinations but in a specific way. For instance 1,2,3,4,5,6

Hi I want to write the Range for a chart dynamically. My code now is:
Range(rng1.Address, rng1.Offset(i, j).Address).Select
   Charts.Add
   ActiveChart.ChartType = xlColumnClustered

I have looked high and dry for this information and cant seem to find what I
am needing to do. I have tried it everywhich way and cant seem to get
anything to work, so any help would be GREATLY appreciated! Thank you in
advance!

I have a spreadsheet in Excel XP format.  It has 16000 rows.  Currently I
step through every row to look to look at the data in column K and replace it
with a new value through a select case statement:
if x then new value is 1

Will the Excel VBA of Office 2007 that ships with Windows Vista at the end
of the year be very different ?
Will all that we know and use today become obsolete ? For example, all the
API calls to libraries such as user32 will become obsolete as such libraries