I have a worbook containing several macros and lots of formulas that
has grown to big. The only way to trim the file size down is to delete
rows containing formulas that are as of yet unused but will be as more
data is entered. These cells will eventually be required to carry out

What im trying to do is this. Have a macro run that opens imports a selected
file, then have it copy and paste into a set cell range of another sheet.
I have it working so that i can select a file and put the file on a new sheet
in my template workbook.

Below is the code for a sort Macro works OK no problem - the question is
that on the sheet there are 20 blocks of 4 line ranges all in the same
columns. How would I incorporate them in this little macro. Ranges are as
follows C2:D5, C6:D9, C10:D13, C14:D17 as so on down to ranges ...

Is there a way to change the search within feild in the replace command from
"sheet" to "workbook"?
ie something like:
Cells.Replace What:="a", Replacement:="b", Within:=xlSheet

Once you have put in the borders etc you want is there a way to keep them
from changing if you copy text.formulas etc.. IR i use the med to large line
fo routside and  it chages all the dime when I copy a smaller line in.
Any Ideas? or is this impossible to control?

I am programming a chart building worksheet with vb, and I must scale
the axes based on a value within my spreadsheet.  Right now, I am
using the following commands:
With ActiveChart.Axes(xlValue, xlPrimary)

I just need to start Solver with code, i.e. the equivalent to clicking Tools,
Solver (which remembers all parameters from the last time Solver was used on
the active sheet)?  Any ideas?

What is the best way to setup Excel if I need to access macros in an external
worksheet and run them in a variety of worksheets? I tried saving them in a
.xls worksheet and then setup Excel to open the worksheet when the app opens,
but the worksheet is always displayed. Should I ...

The workbook I am working on has expanded to 7.5M after removing all
unused ranges using the last used cell approach as discussed on
several posts here,  so I am now trying to reduce the file size using
Rob Bovey's code cleaner. I have installed it and read through the

I want a macro to start at a certain point, move down to the end of the text
and delete the empty space between it and the next populated cells.
Not delete rows, rahter delete cells, shifting up.
I've written:

I'm having some trouble with a Excel macro, which transfers data from
one worksheet to another in the same workbook.
The macro is embedded in the workbook.
It is a rather large workbook with several, big worksheets.

Ok here goes:
I opened Control/toolbox and selected button to make. Edit the button but
what I want to do is have it perform an action in cell below it..ie say
generate a random number or the check box open a drop down menu. Problem is I

I am using the code below to autofit the columns on my spreadsheet.
Private Sub Worksheet_Change(ByVal Target As Range)
Me.Application.ActiveWorkbook.RefreshAll
   Target.EntireColumn.AutoFit

I need to know what formula to use in order to calculate when the sum in
column A is 3 times greater than the sum in column B.

I have a very strange problem with Excel 2003 and also with Excel 2000.
I have a large workbook (~12 MByte) with 9 worksheet.
On this workbook I have a complex vba macro that collect and order the
various sheet's cells data and export views of the data on some txt files.