The questions are probably simple:
1 - can I create a macro that - after pointing (clicking, double
clicking) to e.g. B5 carries the pointer to e.g. W23?
2 -I'd like macro "waiting" after  ActiveSheet.Pictures.Insert( _

when i am opening execl a tab appears that-"please wait while windows
configurs Microsoft Office Professional Edition 2003"after that it says that
"Installation Error File not found","original Installation Source Required:"I
HA DTYER IN ALL WAY,

I want to enter a formula into a cell using VBA but while the formula is
sound it leaves "#NAME?" in the cell until you manually click into and out of
it. Is there anything I can do to stop this?
ActiveCell.FormulaR1C1 = "=ROUND(VLOOKUP(R[3]C,'Part

I am trying to create a workbook with 26 sheets (26 - 2 wk scheduling) for
work.
I was wondering if a macro could execute via command button to copy a
template for a two week schedule 26 times AND label the sheet tab with the

Hello, can anyone help me please!!??
I have a cell named "% Compete" and columns named Week 1, Week 2, Week 3,
Week 4 and so on up to week 28
When the user types in week 1, 50% and then 60% in week 2 I need the cell "%

Hi I imagine this must of come up before and there must be a solution
that already exists somewhere.
I regularly receive multiple workbooks or workbooks with multiple
sheets that need to be combined to one file to produce a list of

I have 2 comboboxes ("Business" and "Name"). When Business is selected I
would like Name to populate with all the names on the sheet that is named
Business.
I have tried the following code but get an error message saying that Name is

I get an error everytime I run this.
I need to find a way to avoid the error but still keep my program
running.
can anyone help me plz?

Hi - thanks for having a look
I have 1 column of names: D (in a many column worksheet) with initials
and surname in upper case e.g. AB PATTERSON or A PATTERSON and I want
the surname only (not initials) as proper.

If I run the cursor over a commented cell, the Status bar
at the bottom of the screen says 'Cell xx commented by' and my name
Can I remove my name ?
Thanks - Kirk

I'm looking at have a userform saved in an Excel Application. The reason for
it being a userform is to give greater control over the options. Once a user
has selected the information and how they want to present it I want the
option to print it out.

I would like to completely control cell comments from a macro form. I am
unable to determine if a cell does not have a comment or does have one. How
do you relate the comment of each cell in a row of cells to its comment
object.  Comment index numbers do not seem to carry any ...

I am writing a macro in an MPP.The macro runs fine for the first
time.But
the next time its run its popping up an Error.But again after clicking
the

I've an Excel Spreadsheet (Report) with n worksheets.
I'd like to create a VBA macro that, when I open the Spreadsheed:
a) asks if I want to add a new worksheet. If the answer is yes, then:
b) prompts a form to input the worksheet name

I have a cell containing formula, that I want to copy to more than 50,000
lines, instead using page down maybe some could tell me a macro on this.
This is illustration:
                                AI4