My goal of my VB form is to be able to select certain things and then
display a filter spreadsheet using the Excel component in Microsoft
Office Spreadsheet 10.0 control.
Can someone tell me how to load an entire excel sheet into my component

Hi, I have recorded a macro as follows:
Range("O5:X200").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
       "A33:J35"), CopyToRange:=Range("A36:J36"), Unique:=False
but when I run it I get:

How can I set up a "conditional" copy and paste procedure?
I need to copy certain values from a column and paste them into another
depending on the date (that is settled in another column) associated to them.
Example:

I'm having problems defining my sumif-formula.  It returns a runtime error
424 and I don't know how to solve this problem.  The formula is searching in
a dynamic range and has to sum the values in a number of specific columns
when the condition is met.

I have a 250-page pdf file.  The pdf file is a checklist which means it has
columns and tables.  I like to convert it into Excel without losing any
formatting from the pdf file.  
Does anyone know of a software to do it or other solutions?  Any suggestions

I made this code to delete a range of rows, but I found out
that this code only delete every second row.
Do Until Worksheets("Materielplacering").Cells(lCurrentRow, 4).Value = ""
       Worksheets("Materielplacering").Rows(lCurrentRow).Delete

I'm exporting a pile of data to tab delimited text and am getting an
extra row in my output that the next program is rejecting.
Is this maybe and EOF? If so, can I get rid of it? It appears to be one
character, which I can then delete in notepad and then save without it

I need some help.  I am trying to use a macro to go row by row and find
the first non-blank cell (which should be a number) and then using that
as a start point apply a 1/12th calculation to that cell and the next
11 cells, but after that I want the range to go back to zero's.  I am

Maybe someone has a hint for me whats wrong here :-)
I have written some VBA code that allows to expand/collapse a previously
grouped set of rows dependent of the state of a checkbox object. Works fine
sofar. Then I have placed a CommandButton within that group, used the

I have created an Order Form in excel, and I am looking to capture the
values that are entered into the Order form such as Company, Location
#, ect., and record them as a record on another worksheet.  Any body
know the code for something like that.

Could you make a "if" formula that would use cpearson's blinking text code
when a cell's variable changed.  For instance: a2=82% (no blinking); a2=78%
(blink).  What would such a formula look like that would have an "if" and
have the "then" refer to a macro look like?

Sub SendActiveWorkbook()
   ActiveWorkbook.SendMail _
   Recipients:="person@gmail.com", _
   Subject:="Test" & Format(Date, "dd/mmm/yy")

I have a worksheet using the rand() function and 3 macros.When I cycle
through the macros on the 5th attempt I get the above message. Is there
a function where I can clear the memory without exiting Excel.
Regards,

Can anyone help.  Is there code to protect a worksheet using the Version
of VBA that comes along with Office/Excel 97.  I understand that with
later versions the follwing would work.
Sheets("Sheet1").Protect password:="anything"

I found several post here describing how to declare a range in Word.
But when itried to declare a word range (Dim myRange As Word.Range) it
gives me an error !?
I am using office 2003 with windows xp.