Hi: I create a new workbook. How to i copy all the sheets from my old
workbook into my new work book. I mean when ever i open my new work
book all of the sheets no i am sorry from sheet1 to sheet10 will be
copy into my new work book will all of the formulas. I am sorry i ask

How do I make my macro save my spreadsheet when I run it?

The below code does not work but I think I just need a small tweek.
Simply want to display the values of two variables in the same cell but
with a space in between.
ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & " " &

Hi to all the excel fairies,
I am using a PDF transformer to get data into excel. Unfortunately the
pdf file has tables that the transformer cannot always read properly,
therefore the data I get in excel has strange formatting errors. I was

i'm having an issue trying to save an excel file containing cells with
multiple values separated by commas.
for example, i have in a cell of the excel file:
myField1,myField2

I have an excel spreadsheet that runs a macro on opening and then
within the workbook there are various buttons running further macros
(i.e. to delete rows etc). After pressing the final button, i want all
evidence of macros to be removed from the sheet. When the sheet is

I'm working on a spreadsheet that is dynamically populated from a
database query.  I don't know how many rows will be returned by that
query.
What I would like to do is have a button at the beginning of each row

I am facing a tedious problem using the VLOOKUP formula.
First of all I give to all a clear picture on what I want to do.
For ex:
A1 -> 1  B1->100   C1->2   D1->500  E1->1

I have the below code kindly provided to me by a user of this forum
Sub deleteincomplete()
'delete all rows that have incomplete data
   Dim rngToSearch As Range

I have an ongoing project I have been working on.  After making some
updates to it this week, the file suddenly started growing in size.  It went
from 9700 kb to 14000 kb for no apparent reason.  (This happens not
immediately after the changes are made, but after a few uses of ...

Title pretty much says it all.
How do I find the last row in a disjoint range assuming they're all in
the same object? ie. What  do I put in here?
Function GetLastRow (Target as Range) as Long

I am using a VBA control - Command button. and I would like to be able to
print a word document by pressing it. The file is a fax cover sheet, which is
an important part of the application I am making.
Is there anyway this can be achieved.

I'm not sure this can be done but I need to detect when a new workbook
of a given name (X) is created on Excel startup. If it is not that
workbook I need to continue as normal. If it is, I need to open another
named spreadsheet (Y), take sheet1 from the 1st spreadsheet (X) and

Having output text from a dos batch file, I read it back into a text
box on a userform thus:
   Open fileName For Input As #1
   Do While Not EOF(1)

I am trying to make a Macro that searches addresses in a worksheet and
replaces "street" abbreviations with fully spelled out words.  I have the
general idea of how to make the macro, but I have a couple of selective
replacements that I don't know how to handle