User trying to find the value on a certain date can enter that date (a1).  
vlookup will search column A for the requested date and then return the
associated value that is in column b.... Column A10:a100 = dates.  Column
B10:b100= values...  =vlookup(a1,a10:b100,2) returns #N/A

i'm adding to a rectangle a text from a range 1 by 1 character like this:
ActiveSheet.Shapes("Rectangle 3").Select
For i = 1 To Len(Range("J17"))
       Selection.Characters.Text = Selection.Characters.Text +

When I'm working on a project that opens and closes other worksheets an
entry appears in my Project Explorer -- often many of them with the same
name.  Is there any way to stop this or to clear it out?  Or am I the only
one having this problem?  I have to periodically shut down ...

In the past month every time I try and click on the
"notify me of replies" icon Iget: the above comment.
What action can or should I take to correct this?
TIA,

I have the following code which does what i need , except it returns the
values to the debug window.
Sub Table_properties()
  Dim cat As New ADOX.Catalog

I have an protected spreadsheet and I want to create a macro that when the
user select a portion of the text in a cell (not the cell), I apply a
standard formating to this particular selection.
How can I do that??

Would anyone have any sample code that I can use to generate a random series
of monthly lognormal equity returns with a mean of, let's say, 8% annually
and a standard deviation of 15%. Many thanks.

Good Day,
I have a cell with this text:
"1 - aaaaaaaa
2 - bbbbbbbb

I have been struggling with filtering some data based on two criteria.
I have used Ron de Bruin's excellent resource at http://www.rondebruin.nl/copy5.htm
as a base but unfortunately I can't seem to get it to work on showing
me the data where a date falls between two ranges.

How would i go about inserting an image to a userform by clicking on the Image1?
I need a prompt to select the image then size it to the Image contol on the userform??
Corey....

I have been running into an issue for years since I first started coding in
VBA within Excel -- it has driven me crazy and significantly effects my
ability to write code without having to record a macro...the issue appears to
be interment and just seems to not make logical sense.

Each month one of systems exports a bunch of excel documents into various
directories.   I am writing a macro that will automatically format each
file.     I've attached part of my code below.   My question is, is there a
more efficient way for the macro to open each file and ...

In Macros i would like to write web query to extract data which consist of
more than 1500 rows, In Visual Basic the tables are mentioned as under
.WebTables = "3"
How can i mention 1500 tables by writing FOR Next....

When trying to export xml from a web url we have noticed some really weird
behaviour.
The xml is off the following format:
<Items>

Is it possible to position or pad a string by the pixel unit? By now,
space() is base on character.
Clara