I have a macro that I created and I have copied the code from it to the code
area for a command button and when I execute the command button it does not
work but if I execute the macro it does. see the code for both below,  I
receive the error Selected method of range class ...

I have a macro that gets data from another program. I want to check that data
and "clean" it ie remove unneccessay blanks etc. The data is stored in the
variable BBAnswer. I then check that variable:
If IsRatingOK(BBAnswer) Then

At times, the program uses the Values property without erroring out, but
doesn't actually set the Values property on the series, and other times, it
errors out.  See the snippet below.
               With .SeriesCollection()

i need to run a for/next loop for a selection which i started like
this:
Range("f3:l9").Select
For Each i In Selection

I have a list of files, with the directory path from cells a1 to a10
and want to check to see if any do not exist.  I would like the file
names assigned to an array in vba, check them off and if one does not
exist stop the code running with an error message.

Hi! I have a problem with a simple code piece. when trying to run the code
below I get the error: "Object required". Please help me solve this! Thank
you very much!
ratingCell = Range("c9")

I'm trying to copy rows from one workbook to another - all those rows which
have the most recent date (date in column c).
Tom Ogilvy supplied this code for me but it just copies one row not all
instances of that date, any ideas???

I am using the SEARCH function to search for a space ("") within a cell such
as follows:
           A
1    I LOVE YOU

Dim WS As Worksheet
   For Each WS In Worksheets
       If WS.Name <> "Detail" Then
           WS.Visible = xlSheetVeryHidden

I use the code below to query against an Access Database.  I would like to
add a password to the database so that it can't be accessed unless you have
the password.
Would anyone know how I would add such a password to Access and how to adapt

i am trying to copy data from various workbooks in excel -(open ones) i
dont know the names, but i do know the sheet is called sheet1 (i
know....)
i need the data to be put into wbMaster (main doc already referenced) -

I have a 2 dimenisonal matrix. I want to find the size of the different
dimensions.
I know how find one dimension by using the Ubound. This gives me x=3.
However I would like to know the other dimension also, ie 5. Can yuo please

Hi. I try to have routines to restore formats on changes, to cover also
drag and drop. I store last selection with SelectionChange and trig
format restore on Change event. I send the current target and try to
union with stored selection address. THERE I get error 1004 - on third

I have a macro that imports data from web and puts it in a data sheet.
This works with a great speed. No problem.

another sheet.

Private Sub Workbook_BeforeClose(cancel As Boolean)
   Application.CommandBars("Pack tool bar").Visible = False
End Sub
Private Sub Workbook_Open()