I have an enormous worksheet that I'm working with. Here' s  a very
small part of it (immigration data):
   A                    B                                     C
                  D

I am giving myself a crash course in VBA programming using
Walkenbach's book.  Hopefully I can figure this out for myself
in due time.  But as a double-check and perhaps for expediency
(learn by example), I would appropriate it if someone would

I have a matrix of 400 commandbuttons (20 by 20) on a Userform and wish
to loop through them, -not horizontally-, but vertically viz.
1,21,31...391, 2, 22, 32...392  through 380,390,400. Since the For each
... Next construct sweeps horizontally, this popular loop fails. I have

Hello to all,
I have read some about sending mail from excel trought Lotus Notes, and
I am working with it, but it´s imposible for me to send a range of
date or a link to a document.

Suppose I have a form with a text box. Does the textbox have an onEnter
event?
Thanks!
Aaron Fude

Is there an easy way to hide / unhide 5 command buttons I have on one
worksheet named 'New Style 2006'
Rgds
Neil

I have several name ranges with large number of rows. I cannot
aggregate my data into only the 4 columns used in the name ranges as it
would exceed 65536 rows.
Here is what name_range_1 looks like (4 columns)

Have a spreadsheet sent to me
about 250 lines, 12 columns.
There are 60 lines of data, two blank rows
'nother 60 lines, two blank rows, etc.

I have defined a custom class called deductionFile.  It has several
properties like fileName,fileDate,etc.  It refers to a fixed-width text file
that I am importing into excel.  The file is comprised of several fields,
and each field has information about it like width, ...

New to this and pulling my hair out!! Would really appreciate it if
some kind sould could put me out of my misery with this. It might
actually be quite simple - but I'm missing it.
I have a template sheet which contains everything I need ( cell

i need make a user form including 2 input box code and qty
cmd button saves code and qty to other sheet in own rows
is it possible anyway
--

How can I generate 9 diffrent numbers from 1 to 9 thats not repeat it's self.
I need the number 1 - 9 in random order.

As a real estate practitioner (newbie programmer in excel) I receive various
schedules of vacant properties from different property companies.
In each there are column headings, but the same data in each column of the
various schedules is usually headed by similar (but not ...

i have declared a number
"dim count as single"
and changed it
how do i copy the value of "count" into a cell

I have a values + or - in one column and the number in the next
What I want to do is add the + or - to the number i.e.
- in one column, 10 in the next you get -10
I know I can do this by using the & function but this is not the way I want