I'm designing a basic wall planner in Excel, and due to the way it is
laid out I really need to have text in certain cells displaying upside
down.  At least, the text will be upside down in Excel - once the
planner is printed out and displayed correctly, the text should run

  I have an excel which has a inhouse format. When a user tires to
paste data onto to the excel he should only be pasting values and not
disturb the format / formulas in the excel.I have implemented this by
using paste special when the user tries to paste.This can be done by

Can please any body know that where and what macro code I can add in
macro below that when ever Text of "ZERO BUDGET" appeares by fromula
in any cell of Range ("K25:K62") then MsgBox should appear saying that
"ZERO BUDGET IN AGRESSO" . can please someone show me the code mix in

I need this macro to be a little more robust. It works but only up to
26.  Could it be the computer I'm on?  If I change the range in the
patient's sheet to only c1:c26 this macro works without a hitch.  If I
add any more rows it crashes.  i need it to copy all the sheets and

As topic says: I would like som VBA code, that runs through all charts
in activesheet and copy pastes them to a new sheet as pictures and
placed above the same cells...
Can any of you out there help me :)

I have encountered a stange bug. The bug occurs when copying an active
chartobject in Excel to PowerPoint.
(Excel is called from PowerPoint.)
The strange thing about this bug is that it occurs *only* on some pc:s not

I am doing VBA for a spreadsheet at work.  The idea behind this
spreadsheet is to have a UserForm that asks for a certain Month
(cmbMonth) & Day (cmbDate) and Dollar Amount (txt.EndCash). Then,
using the Month, it goes to a certain sheet (named "January",

I have a order sheet that has a list of products and there prices.  The
prices are located in Column F.  I want to beable to Sum all the products in
a Cell that is next to a cell the words Sub Total in it.  So I wrote my code
to search Col. E for "Sub Total" and return the ...

Does anyone know how to strip html tags from excel worksheets?
I regularly use a worksheet, (generated by IT from the web), that
creates an excel sheet. The problem is, the html tags remain, making
it very difficult to read. A sample is below:-

     A           B      
1  Apple      44 (with red-arrow comment "fruit")
2  Pine        55
3  Apple      66

I've spent all day trying to make a macro available to all of my Excel
files.  The option I chose was to create a personal.xls file and put the
macro there.  That makes it available.  I can "Run" the macro using Tools >
Macro > Macros > Run.  But when I setup a shortcut key for ...

OK, I have  an interesting issue.  For the most part my macro seems to
work for creating and updating charts dynamically.  But I am running
into an issue.  If the chart data gets too large then it drops some of
the selections and errors out.

Hi, I made a 2007 payroll withholding tax chart, and forgot how I did
it in Excel. I have the chart for a single person and a married person
but can't figure how to get the rates for married with 1-2-3 & so on
dependents.

Can please any body know that where and what macro code I can add in
macro below
if I want MsgBox to appeare saying that "ZERO BUDGET IN AGRESSO"
when there text appeare of "ZERO BUDGET" in any cell of Range

Anyone knows why this does not work - i.e. the even sink
excel_SheetChange never fires?
Dim myExcel,myWorkbook,mySheet
Set myExcel=WScript.CreateObject("Excel.Application","excel_")