What I want to do is copy the formulas from a contiguous range on sheet1 to
a safe place (say sheet2) so they can easily be restored later, if someone
mucks them up.
Any assistance at all will be very much appreciated,

I've built a pivot table programmatically in VB.net using the Excel OM . The
columns of the table are Jan, Feb, Mar, etc. and I would like to group them
programmatically into Quarters also but can't figure out what the code should
be. I'd also like to have subtotals for the ...

In this and other Excel NGs, I see quite often VBA lines like:
sub Foo()
dim myRng as Range
dim myRS as ADODB.Recordset

I have a UserForm that will show all the data from a record based on a
PO# the user enters. It worked fine, but it was designed rather sloppy.
I wanted to incorporate a FindNext, and had problems. I ended up
replacing the Find coding based on some valuable help from Jim

I have written the following to open up a different user form when certain
cells are changed  (The User answers "Y" to the question).  This part is
working.  My problem is when I reset the worksheet to the default values of
"N", the worksheet views this as a change and is popping ...

I have a protect sheet with only few cells where users can enter data.
Is there anyway to restrict users not to do a copy paste in those areas?
Any help greatly appreciated.
Thanks

I have a spreadsheet where I create a custom menu added to the Tools menu
when the workbook is opened.  In the ThisWorkBook object, in the Sub
Workbook_Open(), I have code that looks something like:
Application.CommandBars("Worksheet men

Excel 2002, WinXP
I have an OP who is getting stock updates through a Dynamic Data Exchange
(DDE).  He has a column of formulas that pull down the data.
   He wants something to happen when the contents of each of these cells

Can I get a button on a toolbar to be shown as pressed in Excel?
I've asked before in an Outlook NG and got it to work in Outlook, but
I've forgotten since then (I'll have to wait til I get home to see how
I've done it).  I've looked through all of the properties and methods

I have a workbook template that is opened "externally" via code---a
VB-like form opens the workbook and creates a new worksheet. I don't
have access to this code, but I do need to add code to the template
that is triggered either upon open or creating the new sheet. However,

Enter a number into an active Cell and want the same cell in every othe
sheet has the same number entered. Does anyone know how to do this b
using form
--

I have an odd problem and was wondering if anyone had some insight to
my issue.  I have some code which appears to run perfectly fine under
normal conditions.  I can run multiple iterations w/ no issues what so
ever.

on sheet2, i have the following table
col1    col2    col3
A    1    10
A    2    11

I am trying to create a pivot table in a specific cell on a sheet. The
code I have is below. Basically I want to create pivot table so it
appears in the cell I have named as PTCell. PLEASE HELP as this does
not work

What would be the code to move the columns "J" "K" "L" & "M" from one
Tab labeled Invoice to Another labeled Master.  They would need to be
moved to the same columns. (Hence J, K, L, & M)
Thanks,