Below is the code I am using to insert a blank row between text pasted to
Excel at various times.  However, I would like to add a test if a blank row
exists between rows of text, then do not insert another blank row. Here's
what I currently have:

How can I setup a macro that will pull data in from a range.. From one
xls spreadsheet(testLog.xls)(summary tab) to another
(Script.xls)(findings tab)?

I need to use vba to make a pivot table's criteria equal the contents of a
cell.  Any code/help would be very much appreciated.
Thank you,
Nick Cherry

I've succesfully built a macro that run 2 solver commands in 2 separate tabs
of the same workbook.  However, If I protect the worksheets with passwords,
the solver macros trigger an error message - error in parameters or
contraints. It works if I unprotect and then protect within ...

The following code fails at line 2 with Object vaiable not set and I cannot
find the correct syntax.
The proc refers to 2 optionbutton labels in a frame on a multipage hence
needing to use SelectedItem.

Hi All,
In excel I have 2 sheets (Sheet1 & Sheet2), in the same
workbook(Book1.xls). Sheet2 is refering to Sheet1 to get values in
different cells in Sheet2.

I have a spreadsheet that has a menu bar item (on the same line with
File, Edit, View etc. ) that is mispelled. I can't find that menu bar code.
I can find the
macros that it points to, but where is the code for the menu bar itself?

I don't know if anyone could help with this. The idea is fairly simple.
At present I have a macro that searches for a file. Each file name is
47 char long and is found using
Set fs = Application.FileSearch

I am trying to open a word dopcument from excel...below is the code I am
running but I receive the following error....that is runtime error
524...which indicates that the file does not exit...but it does. I searched
through the other questions and did make sure that the microsoft ...

I've worked myself into a corner and could really use help with 2
separate problems - this will probably require programming that is
beyond my skills - but expert advise would be appreciated to determine
how I should approach this:

I import data from a source and it has 1 blank row between rows of data and
notes.  I need a routine that will find that blank row and delete it and move
the remainder of the information up.

I cannot insert a page break on several sheets in my workbook.
I have tried inserting a page break in my code and also manually.
Any ideas?

I am trying to sort a range in my worksheet.  
I create a worksheet pulling data from other spreadsheets.  I go through a
directory and advance rows by using x+1.  At the the end I don't know how
many rows I have and I don't want to hard code it.  How do I use a variable

The problem is (at least) two-fold as I see it.  
The problem:  I would like to review the time/date of the last x changes
made to a spreadsheet and who made them.  
The spreadsheet is distributed among a closed network and I just want to see