Search:

I have a multi-section document with a form in one section. When the section with the form is protected ("Filling in forms"), it is still possible to edit text in an unprotected section, but I...

Thanks for your input, Hans.

The CreateDate() function that you suggested works, but unfortunately, the date inserted is not the "date created" that is shown on the File - Properties menu. When I...

I want to automatically insert the date a workbook was first created (from a template) in a worksheet. I don't want the date to change when the workbook is subsequently reopened. If I could insert...

I have an application that cuts and pastes a range of cells, which include combo boxes and drawing objects. The combo boxes and drawing objects are supposed to move with the cut and paste. They...

Thanks Hans.

After I posted the question I came across a solution in a book by John Walkenbach:

InRange = False
If Union(rng,Selection).Address =Selection.Address Then
InRange=True
End If

I want to test to see if the selection is within the limits of a specified range. For example, if the range is A1:D4 and the selection is B3:C3, the result would be true, but if the selection is...

I use the "insert date" tool to insert a date in a footer, but I want to change the date format, for example, from 9/19/05 to 19 Sep 05 or September, 19, 2005. It there a way to do it?

I have an Excel application that solves a series of equations by iteration. If a user opens the workbook and the tools-options-calculation-iteration box is NOT checked, he gets a circular reference...

I have a worksheet that calculates values in a table based upon a selected data set from another sheet. In some cases, values are missing from the selected data set. The missing data causes #DIV/0,...

Is it possible to insert a variable range name in a function. For example, the user selects a range name from a drop down list in a combo box -- mfgr1, mfgr2, mfgr3, etc. Each range name refers to...

I would like to change the order in which the fields are selected when tabbing between the fields of a form. The form has many fields and the standard left-to-right, line-by-line selection process...

I work in two time zones and sync between a laptop and a pocket PC. When I have made changes to the time in either my laptop or my pocket PC, previously scheduled appointment times have been...

Thanks Leif.

I am having problems transferring Outlook 2000 files from my old computer to my new computer running Outlook XP. After much frustration, I have transferred the files. However, when I try to address...

I use a drop-down list for data validation in a cell. The drop-down list shows 8 entries with a scroll bar for additional entries. Is it possible to increase the size of the list so I don't need to...

I want to print a two-page-per-month calendar with Sunday in the first (left) column and Saturday in the last column. I have tried all the page setup options, and I always get a calendar with...

I use a formatted template for process analysis. The template includes colored highlights and bold lines to separate different sections. The cell formulae however, are different for each process,...