Search results for query: *

Does the following help? http://www.ozgrid.com/VBA/autofilter-vba-dates.htm

A description Column already exists. If you right click on the heading you get a menu with additional fields. Click on "More.." at the bottom and there is a description field in there.

Taken from Excel VBA help, but same should apply: "If prompt consists of more than one line, you can separate the lines using a carriage return character (Chr(13)), a linefeed character (Chr(10)), or carriage return – linefeed character combination (Chr(13) & Chr(10)) between each line.

Have a look at conditional formatting, under the formatting menu.

Can you post the code that you've got?

Check out Validation under the Data menu. Set the Allow Criteria so that the text length is to be less than or equal to 255.

Under Data, Filter, check out the advanced filter, where you can filter out unique values to another location.

How about: =IF(MOD((Value1-Value2),2)=0,"OK","FALSE") Where the 2 is the mutiple you want to check.

There's probably a better formula, but this should do the trick: =IF(B1>C1,IF(C1>A1,"True", "False"),"False")

Check to see if it's a shared workbook. Go to Tools, Share Workbook. If the Allow changes box is ticked, then you can't merge cells. You would have to un-share it first.

Have a look at the application.displayalerts.

Alt and Enter?

Is the scroll lock on?

I think it depends on what you are trying to accomplish. For me, the escape key is for resetting, so when I want to use it I use "<Reset>". What actions are you trying to perform that require the ControlKey?

Instead of using the left mouse button, use the right to drag to where he wants, then select the Copy Cells from the item menu which should automatically open up.

You can do this in the Status Bar. Code from Combo a long time ago: Place this in a standard module. Sub xlTimer() With Application .StatusBar = Format(Time, "hh:mm:ss") .OnTime Time + TimeValue("00:00:01"), "xlTimer" End With End Sub You can start it in open procedure (Thisworkbook...

How have you set it up? If you have say Cat as your rows and Time Range as your columns, then add time range into the data items, set as a count, then this should give you what you are after.

The easiest way is with a pivot table

As you are saving the workbook with a name down to the second, I would apply the time to a variable and then use that to save and close the workbook. tim$ = format(now, "yymmdd_hhmmss") ActiveWorkbook.SaveAs Filename:= _ "C:\ resultaten\resultaten" & tim$ & ".xls", FileFormat _...

Presumably your trying to close an Excel workbook if your getting this message, in which case try using: Workbooks("YourWorkbookName").Close (False)