I've built an optimization model and I would like to create a map-like
interface on a worksheet in which selected sites in the solution are
indicated on the map canvas by unhiding drawing objects.  So I need to
place the drawing objects on the worksheet as Controls (i.e. Shapes I

OK, I have tried multiple ways of creating a schedule for my employees and I
have looked at multiple POSTS, but the one I think might of helped me I can't
find again.
So, please help me finally figure this (probibly easy formula for you, just

i have very large file(~13000) i did some conditional formats deletion via
macro. i also saved the file via macro.
i noticed that the file size was reduced(~9500). but if i open the reduced
file and close with save it size becomes even smaller (~8000). i believe

Can anyone tell me how I can create an excel check box from a list in a
worksheet? I am trying to give users the option to print certain reports for
companies, but since company names can change frequently, I wanted to have
the source list in a spreadsheet so that you dont have ...

Hi guys..
I'm gonna build a COM add-in for Excel 2003...
I downloaded an example from http://support.microsoft.com/kb/230689/
but I need some explanation about COM technology...

Is it possible to highlight these datas in a sheet using conditional
formatting as :

1234567ab ( there might be 1 or 2 alpha after the numbers) as blue, and

macros as below :-
Private Sub MODA()
   Application.ScreenUpdating = False
   Application.Calculation = xlCalculationAutomatic

I have a problem developing some code which can handle copying data from
Excel cells to Word bookmarks based on a Word Template.
Its preferred that the user must start saving the Word document with a new
file name before the bookmarks are receive the data from the Excel cells.

There may be more but when applying logical tests to a cell to check if it
is empty there are 3 common ones that seem to be used...
Range("A1").text
Range("A1").value

What is wrong here?  I have a 2D array.  The following gives me an error say
it can't find Match property.  I am trying to locate first row with 0 in a
sorted array (high to low)
MaxRow = Application.WorksheetFunction.Match(0, ConsFunctionArray, 1)

What I really want to know is how to parse the range value  in the
case of  the "All" selection in the user form?  The user form loads
so I will forget about the rowsource. I need to loop through the range
and print each row in the cpyAllPatientsShts() .  So it would be a for

I need a piece of code which will look at column C and find the first empty
cell in the column (must be below row 6) and then select the cell in column
B of that row.

hi. how do i make a macro that returns the value of the cell next to the word
"total" from all worksheets which are listed in column A?  i got to make the
macro that lists all worksheets in that workbooks into a summary worksheet.  
Now i would like to find the value of the total ...

I use the code to copy data from a temporary worksheet into a production
worksheet and it works fine with the  "ActiveSheet.Paste"  line near the
bottom. The problem is that I need to use PasteSpecial instead .  I tried
using  " ActiveSheet.PasteSpecial Paste:=xlPasteValues"  but ...

I have some problem in my excel when the user clicks the "Design
Mode".
I have protected the Workbook, Worksheet and the VBA Code as well.
So, although the user cannot enter the VBA Code, when he selects that