I have a command button in my excel file after clicking on which it
does some calculations.
I need a small piece of code at the end of my code which will save a
copy of that file (Save As) in C:\ with the current date and time (eg.

I am running an excel-vba which requires the user at a certain point to
manually export an excel file from a different software. The problem is
that this exported file opens up (automatically - which is how it is
supposed to be) in a new excel instance meaning it is not part of

I am looking for VBA code that simply returns a boolean value based on
whether a pivot table exists in a worksheet.  Code I have come up with is
below:-
Dim ws as Worksheet

I have over 2000 account numbers, each with it's own account balance.
However, I need to map some of these accounts together such that their
balance is consolidated. e.g. If i have 5 accounts viz 111,222,333,444,555
each carrying a balance of 2. I need to map these five accounts ...

I'm trying to put together a macro that will take a value from one cell in a
row, and then move it to another cell in the same row. The originating cell
is going to vary, but the receiving cell is going to be in a constant column
in the same row. I know about using offset to move ...

I have a question very closed from closed subject (IMPORTING 100 TEXT
FILES INTO EXCEL AT ONCE, WITH LABELLING): How to import all the .txt
files from a folder, and import them in seperate worksheets? I mean : I
have several txt files and I would like to have them imported, each of

I have searched hi and low for an answer and hoping that soemone can help me.
I have an Excel workbook that will protected so that no changes may be made
to it with the exception of myself and 2 others.  The workbook needs a print
button that will only print of Task pages (ie page ...

I  have an array of unlocked cells that constitue a range:
  e.g.                      d7  h7 d8  h8 d9 h9  h10 c12 f12
I would like the TAB and ENT keys to always negotiate the range in an
explicit way.

Is there anyway to easily set up an array of cells, wherein each
element of the array would be a cells object? Do I need to set up a
class or is there something in Excel that already does this?
Im using Excel 2002.

I wonder how do *real* VBA Gurus (TM) implement an associative array.
I do it like this:
- create array of keys
- create separate arrray of values

trying to set up a code so to send the value of a cell in an email
message as an event gets triggered - just the value of a single cell to
paste it on the message not the full worksheet.
Found this

What is the code to put a seperator line, between buttons,
on a toolbar or command bar, that is created in vba
--
Desert Piranh

I see There are a couple like these and eah one has a different answer.
Everytime It gets to Range it falls over, it does this with all macros
that i have recorded that use a referrance to range. Any suggestions?
Sub tidypasting()

trying to set up a code so to send the value of a cell in an email
message as an event gets triggered - just the value of a single cell to
paste it on the message not the full worksheet.
Found this

Excel 2002, Windows XP Version 2002, SP1
I have a RefEdit control on a UserForm that has both Change and Exit
events working without a problem.  I subsequently defined a Class
module that would contain a RefEdit control and moved the UserForm's