Any idea how to write a macro that will:
- copy the columns (say rows 4 to 100) from each sheet within the active
workbook where the value in row 3 = value in cell A1 (there will be only one
column per sheet satisfying this condition - it should give an error if

Dear all,
I am eager to know how can the normal icons like "autosum" be triggered
(just like effect of clicking the icon) in VBA ?
Rgds,

How can I distinguish if a cell has formula entry (ex: =sum(A1:A25) ) vs. a
simple "numeric entry (ex: 123)?
-would the most efficient way be to check if Right(AnyString, 1) = "="
thanks in advance,

I am working on a excel spreadsheet. It contains text dat and numeric
data. what I am looking for is that I need to convert that numeric data
into 0. I mean there are cells which contains values like 234, 22, 12
etc and they blank cells in between them. So is there a way by writing

Does anybody know where I can get this?

Hello kind helpers,
I am looking for the definitive guide to creating user forms with VBA (of
course) in Excel 2003.  Anyone found any good sources?  I want every nook and
crany written about, exposed and lots of helpful creative ways of creating.  

Is there a way to set up multiple different excel document files such that
altering one will effect various parts of another different excel document???
 I have a system of sheets for individual clients, and the information on
those feeds the main one for quick reference.  SO, ...

I'm having trouble programatically creating a pivot table.  If I step through
the code below it works, but if I run it, it falls over on the Set PT line.  
Can anyone see a problem with my code?
Thanks

...this is more a windows question.
i've started to use Excel2003 on XP
when more that 1 workbook are open I get more than one little Excel
window in the toolbar at the very bottom of my screen, therefore if I

I need to find a way of exporting everything 'custom' related to my
file, so that I can allow other users to run reports from the file
without coming across run time errors due to custom_types not being
available on others' PCs.

I recently heard about VB-lite.
Need to look into this...
Wondering what other testing apps are available to VBA.
thanks

I have a function that opens Outlook but then loops continously until
the Sent Items Folder count has incremented by 1 (confirming the email
has been sent) but IF the user decides not to send the email, and
closes excel then the do loop will carry on and on (like a duracell

Any clue why when I do the following assignment to a listBox it reduces
the size of the list box
[...]
lst.List = Application.Transpose(lstv)

I have a workbook with 6 sheets. Sheet one being the master sheet.
In Sheet 1 (Master) cell "H3" has the following formula =Sheet2!F3 and
is formatted as a date format (Eg. 31-03-06)
At the moment on "Sheet2!F3" the cell is blank / Empty but on the

On opening a form, 6 txtboxes are populated with column letters IF a field
name is found in data with a variable number of columns and field names in
varying order.
This code seemed to work fine but not always