Hi everyone.  Somehow I think I should know this but the answer is
just not stepping up.
In Excel for example I know to use this formula for finding out if a
cell has data in it.  =IF(F18<>"","Yes","No")

I'm trying to make the Printer Setup Dialog available to users.  The Excel
file is accessed and opened from a web page.  The following code works fine
if the file is opened in Excel, but if the file is opened from IE I get  a
Run-time error '1004' Unable to get the Show property ...

I am creating an invoice with the following auto sort function:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("d10:d28").Sort Key1:=Range("d10"), Order1:=xlAscending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

I've formatted a worksheet to represent an office plan. I have shapes and
grouped shapes to represent assetts
What I want is to click on a shape, returning the name of the shape selected.
I would use this name to get associated information from a database

I would like to create a macro that can help me to compare the 1st decimal
point of floating numbers in a data list; then round up the number based on
the condition below:-
- if the 1st decimal point of the number(s) is .3, for example 2.3 / 8.3 /

I'd like to programatically apply a hyperlink to an active cell that will
point to a named range on another sheet in the same workbook.  I haven't had
any luck with the following code:
********

I have to pull data from various databases, who have some crazy date formats.
In most cases, I have to drop the data into Excel anyway, so I created a
macro to "fix" all the dates to all behave the same, and appear the same:
Sub DateRemoveZeros()

Here is my (broken) attempt at using SendKeys, if you could please help me
fix:
  Selection.NumberFormat = "m/d/yyyy"
' not enough if Windows Regional Settings and cell values are both mm/dd/yyyy

Hey All,
Long time user, never posted though. Here I have about 15,000 rows of
data, all which have formulas in columns K:V. I select all of the rows
which contain a "9" in column T as the value in the cell and cut and

Hey Guys.
I was wondering if you could help me. A few months ago, you guys provided me
a link to code for generating Lotus Notes email through excel. It worked
great and I was able to modify it to my needs. (Thank you so much!)

How can I use macro to print the same range for all the workbooks in a
specific folder.
Thanks.

I'm trying to change the FaceID of a custom button on a custom mene.  I can
access the buttons on built in commandbars but not the custom menu as shown
below:
This works:  ?application.Commandbars("Format").Controls.Item(1).Caption

I'm making a calculator type userform. It will be easier to use that for
someone to find a calculator, and will have additional options for inserting
values into the active sheet.
I've made the *current* buttons on the userform look exactly like the

Im am creating a user interface in Excel to keep track of a workflow
and I have two questions:
1. One of the steps in the workflow is to "upload" a document to
verify that the document has been created. I use a button (code below,

The line below seems to open the file ”book1.xls”:
Workbooks.Open “C:\famous\book1.xls”
I will need to easily change the path location of a workbook, or change
the workbook name without going back into the routine to do it, nor