I have a task before me I need help with.
I have a customer (My Boss) who wants to hide 2 columns in a
spreadsheet automatically when a specific text is selected from an
"autofilter list" in a different column.  Then, show the hidden column

Every other cell in Sheet1 Column A from A6 to A 42 has text/numbers
copied from other workbooks.
The cells are formated as General.
My objective is (in those cells) to have the text or numbers followed

Is there a way to use the format painter in VBA? I mean, basically
copying all the formatting properties of one cell into another cell?
Thank you in advance!

I’m a macro novice who needs help with table-driven copy & paste macro.
I have several worksheets that have macros that copy a source range to a
destination range. Both the source range and the destination rage are named,
but may be on different worksheets within the same workbook ...

I have noticed a lot of tools on the web that claim to be able to "crack"
passwords to excel and other office tools. Parts of the system that I help to
develop depends on excel file passwords to protect sensitive information and
code. What's the nature of the vulnerability? Has ...

I want to use a common set of 7 commandbuttons as a 'menu bar' on
several worksheets (each commandbutton opens a worksheet instead of
using the standard tabs)
What is the best way to go about this to minimise code?

I am trying to delete rows based on conditional statements.  For example,
delete row B if cell B3(budget balance) is 0.  I am having trouble figuring
this out.  Can I incorporate a macro that deletes a row into an "if"
statement?   Thanks.

The following macro call works fine when a specific cell is updated. How do I
call the macro when the worksheet is first opened?
Private Sub Worksheet_Activate(ByVal Target As Excel.Range)
   If Target.Address = Range("hanwono").AddressLocal Then Call

Need help. I need a macro or program that can sort and copy the
information I enter in one sheet over to another sheet. The information
needs to be sorted by name and filed on the distention sheet in that
order. As I enter the information or by a command.

how I union this 3 arrays ?
example:
A = array("mary", "john")
B = array("Peter")

Hello world:
I'm using Excel 2003.  I'm baffled.
Something that has worked for me since Excel 5 no longer works.
Maybe someone out there can explain what I'm doing wrong.

Can someone fix the following for me?
Dim n as Long
With ActiveSheet
For n = 1865 To 1 Step -1

I dynamically added a CommandButton using the ADD method as shown below. Now
the problem is:  How do I define?,create?,handle? the click event that is
generated by that control. I have tried putting in event handlers named:
Private Sub CommandButton1_Click()

I am looking for a way to automate excel macros to run on a 30 min intervals
without interaction.  Is there a code for this?

I currently use the following code to delete the entire row if it empty
in a selection.
Code:
--------------------