i have a commandbutton on an excel worksheet. on my operating system the
code bellow works but on another computer it prints : run-time error '438'
can you help me to solve this problem?
Sub CommandButton1_Click1()

Why macro dont work in Excel 2003
Application.VBE.MainWindow.Visible = True
Pierre

Hopefully, someone has seen this & knows a work-around - it's making me
crazy.
I'm developing a set of macros (on Win/XP) and testing them on iMacs.
When I open the workbook, I execute (from the ThisWorkbook.Private Sub

Can someone kindly provide me with a web link to Bob Phillips treatise
on NAMES? Haven't had any luck with google search.
Thanks.

I have a big Excel file and a macro which processes this Excel file and
spits out a text file. Is it possible to run this macro without opening
the Excel file? Opening a 100MB excel file takes time and doing it 100
times over is not fun...

I need to take 700 addresses telnet to them / menu through 3 pages then
extract the data from three area's and place it into an excel spreadsheet
automatically. This involves 700 multiple IP address, login (all should be
same), password (same), entering menu option 1 twice then ...

Ok, so I write myself a macro at home in excel xp, which works
beautifully.  I send it to myself at work, where I have excel 97.
Still works beautifully.  I send it to the person sitting next to me,
whose computer was built on the same image as mine and also has excel

1st, am not a guru, but not a newbie either. I do 50 lines of VBA a
month.
2nd, I have an active case with MS re VBE killing a workbook, all after
I upgraded to SP2.

i want to add a combobox in a cell, and when i drag it down, want that it
applies to the next cell as well, like what normally happens when we drag
down a formula...
I saw in someone's excel sheet that this combobox appeared only when we

G'Day guys,
need some help with this code. am trying to do a graphica
interpolation by VB.
I have attached a simple example of what I need. The values column nee

I remember reading a post on how to add a standard button (say... the
Bold button) to the menu  next to the Help menu.  But I've looked
around and I can't find that post anymore.  I don't need to do it
programatically, just manually.  Thanks.

I'm fairly new at XL programming and I need a bit of help.
I have a worksheet that contains, among other things, 5 command Buttons.
Part 1:    The 40+  lines of code in each button is identical, except for
some range references.  (  eg cmdA,  cmdB ...etc   refer to Range(D5:E25),

Is it possible to copy the contents of a comments box to a cell on a
different sheet using VBA?

I currently have this in part of my Sub, which basically selects a range
from the active cell to the last nonempty cell.
Range(ActiveCell, ActiveCell.End(x1Down)).Select
Question: How do I get it to select the first cell that is empty?

I currently have this in part of my Sub, which basically selects a range
from the active cell to the last nonempty cell.
Range(ActiveCell, ActiveCell.End(x1Down)).Select
Question: How do I get it to select the first cell that is empty?