Hi All............
I am making a small program in which I open a second Excel workbook and
extract a sheet from it into my Main workbook.  I do not know the name of the
sheet, and assign it "UserSheetName" variable, and then I can populate and

I have the following code that works on some computer but not on others
It gives the error Project or library not found
Public Function UserName()
UserName = Environ("USERNAME")

I've made a custom function and I want the value displayed in the cell to
show up as a percentage but don't want to have to togle the % style manually
every time I use it. I've tried everything I can think of to get it to show
up as a percent but get the #VALUE error every time. ...

I need help with this loop that I created, but is giving me the wrong
results...what am I doing wrong?? Any help would be greatly
appreciated!!!
    A            B           C D E F G H I J

All,
I have a work sheet with data like this
Col A___________Col B___________Col C___________Col D___________Col E
9812___________ Joe____________________________________________125.00

Range("A7").QueryTable.Refresh BackgroundQuery:=False
Can someone please explain why this is = False.
This line of code is for refreshing a query so I do not understand why it is
False.

I would like to find out if it is possible in Excel 2003 to build a
list box that does the following
If a field Cell A1 is populated with cc=23456 or cc=12345 or cc=45678
(CC is Cost Center)

How do I find links to other data sources in a spread sheet?

I'm not sure if this is an Outlook issue or an Excel one, but thought
best to start here. I'm using the following code to send an Excel
worksheet via Outlook. The issue I'm having is this...when I send the
e-mail it's about 99kb in size, but when the other users from my team

I am using a macro to copy|paste "special formulas" over an "identical" copy.
Both worksheets have identical named ranges and the formulas referencing
them won't change either.  The only thing that is different when running this
macro are some of the data values.

I am new to programming macros in Excel.  I would like a simple macro that
goes to the next cell in a column that has data and copy it then look for the
next one and so one.   Any suggestions would be great. Thank you.  
Gary

I have this snippet of code in a large macro:
   ' Refresh screen
   Sheets("Pivot Table").Select
   Application.ScreenUpdating = True

Do you know of any university courses in VBA?

When a user saves a workbook, you can not trust the user to save while
residing in a preferred sheet.  Nor can you trust that the sheets will
always have the same name as the previous workbook.  I need some code
that will move my VB process to the first sheet, or leftmost, sheet in

how to compare two string values, if the string values r from inputbox
in VB
eg A=inputbox(" enter name1")
  B=inputbox("enter the name2")