Recent content by Molby

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.