probably this question is so open, anyway.
I am looking for a good  activex data object excel vba book.
A good one that cover all the topics  to work with:
Excel to get info from access using vba.

My range, C2:AA2 contains weekday dates for any given month.
I want code that will look through that range and find the last Friday.
eg. lastFri = ActiveSheet.Range("C2:AA2").Find(<the last Friday>)
For my needs, this must be a VBA solution.

Hi I have a workbook with multiple worksheets.  For each worksheet I
need to define a range of cells (called for example TestRange), but the
range of cells to be defined with this name on each worksheet can
differ.  I have tried to define a cell range with the same name on

Ok here is my formula
=IF(N3*$o$1="","",(N3*$o$1)
I copied the formula down it works as long as there is a value in say N3 if
there is a formula in the column the result is #Value!

I am trying to get a function to return the values stored in a
user-defined type. The type has two fields: the first field is a Double
and the second field is an Integer.
I realize functions can return more than one value by declaring them as

I have a excel program which uses a look up table to insert a value
in a cell when a code is entered in an adjacient cell the price per
item now needs to be updated in the look up table but im having
probs doing it.

I am totally new VBA. I need to copy data from Sheet1 and paste it to
Sheet2. The data in sheet1 changes every day and I need to append the
new data to page 2 on a daily basis.
I found the following code in this forum (by rondebruin) but is giving

There seems to go something wrong, i've posted this question four times
allready but it does not seem to appear, therefor here it comes again and
hopefully it gets thru.
Here's the code i use:

Can anyone help me with this problem?
I have a series of checkboxes on one form which allow user to select
any mixture of checkbox and click on the generate button to transfer
the selected worksheet's data on to a consolidated worksheet.

I have createed an AddIn following the steps outlined here
http://tinyurl.com/genql.
So I have an addin *.xla file. I have successfully added it through
Tools --> Addin, and checked the box next to my Addin's name.

I have three file paths a1, a2, a3. How can i send an emai that would
open those files in a1,a2 and a3 cells and send mail with an attachment
of those three files.
hope i am making it clear

Hi everyone.  This is my 1st post here.  I have done all kinds of
searching for my questions and haven't found an answer.  I finally
found this sight.  Didn't find my answers (yes I did seach) but at
least I found somewhere to ask them.  So here goes...

Can anyone help me with this problem?
I have a column of data with mixture of text and number.
I want to convert the whole row to text instead to mixture.
I know in excel, to make a number to a text you have to add a ' infront

Hi to all
I use the following line to select a range of values.
ActiveSheet.Range("A1:C" & ActiveSheet.Range("A1").End(xlDown).Row).Select
The problem is that I want to go down to the last row with actual values,

There seems to go something wrong, i've posted this question three times
allready but it does not seem to appear, therefor here it comes again and
hopefully it gets thru.
Here's the code i use: