I am wanting to setup  a spreadsheet to work something like a
database. I want a name to be selected from a list (I can make the
list many ways, not a problem) and then that persons picture appears
on the spreadsheet. How can I go about setting something like this up?

I want to copy an entire worksheet from an inactive workbook without opening
it.  Would someone be so kind as to talk me through this? For more
background, I am having the user enter a list of file names; I want to
automatically copy a certain worksheet (same name each workbook) ...

Hi All.........
I've used this line of code in past workbooks and it worked fine for
appending a date on the end of a filename
Fname = Fname & Format(Date, "_Mmm_dd_yyyy")

I have come across a strange problem while using the Autofilter in
Excel Macros.
I have to Filter my data based on two columns. In One column i need to
place the filter with Entries equallying #N/A. And in the second one

Good evening (european time!), Excellers,
One of my user-defined functions connects to excel with ADO to retrieve
some data (from a closed file). Can  I assign the retrieved recordset to
a variable for further editing in another sub? I get an error message at

I want to learn to create a personal macro;  I readed about lear Macros in
the help, but i dont know the especific function to program a Macro

Hi all--
I'd like to be able to select a range of cells, search that range for any
cells that contain a number (format is set to "General"), and then, if a
cell contains a number, change the Format to "Text" and then add a space

Hi group,
I am doing a find for text. I thought i had to Set as a range, then do the
"Find" then select it, but I am getting an error.
This is the code I have that produces the Error:

Hi
I have a column of numbers - (telephone numbers actually) and I need
to add a leading zero to each one.
Is there an easy way of doing this other than converting each number

I am trying to fill a listbox with data from a hidden Add-In Sheet.
I have tried a lot of things:
listbox1.RowSource = ThisWorkbook.Names("NWD").RefersToRange.Address(1, 1, ,
True)

I have a multiselect listbox where users can select different options that
will eventually be graphed. There's is no code for the list options. I used
the properties boxes for the listbox. I want the user to be able to press a
command button after they've finished their ...

Apologies for starting a new thread, however I could not see a means
of adding to the existing discussion
http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/
thread/81c60da27259942/c4c92231919ed6bd?lnk=gst&q=array+after+code+execution&rnu
m=1&hl=en#
Unlike ...

I want to be able to create a macro where if you click a button it pastes
values from say column Q to column C.  However, I only want it to paste the
info. over if the number in the first row is not zero.  If it is zero, the
macro will do nothing.  Every data set I am looking at ...

I'm trying to write a small macro just to automate an uploading process.  Now
I'm not sure of the command to use but I want it to autofill down but only to
where the info stops.  For example,
A                    B          C

I need help getting VBA to recognize the cell in which a checkbox
resides.  Is there a way to know the cell position based on the
location of the control. The code I am using is:
 With ActiveCell.Interior