Search results for query: *

I want to select all the sheets in my workbook and set the same print area for them all. Any idea how I can do this quickly and easily? I have already tried: 1. Selecting all sheets, Select FILE then PRINT AREA but SET PRINT AREA is greyed out. 2. Selecting all sheets whilst in "Page Break...

I have a set of workbooks "T10", "T20", "T35" etc. all set up in exactly the same way, dates in column A and project numbers in row 1. For your information, project numbers in Book T10 start with 10, project numbers in Book T20 start with 20 etc. DATES 10344 10543 10641 10984...

I have quite a large spreadsheet that i'm having problems sorting. In simple terms: I have two sheets in a workbook that are set up in the same way, dates are held in column A and projects across row 1. Sheet1 holds 'cash in' data and Sheet2 contains 'cash out' data. To save the user some...

When using check boxes in excel, is it possible to change the 'tick' to another character, such as a cross? I've seen it done in word using vb, but am having difficulty finding any examples where it has been done in excel. Regards, Le

I am having a problem creating a formula when using custom in data validation. I want the entry in the cell A9 to be restricted to a 6 or 7 digit number or the text "O/H". I am using the following formula but it currently evaluates to an error: =OR(A9="O/H",AND(A9>=100000,A9<=9999999) Can...

I follow the values through the code and the variable AReceipt does set to True if the user presses Yes in the message box, however when the email is sent the receipt is never received. Here is the code I am using: 'Does the user want a receipt ReceiptRequired = MsgBox("Would you like a...

I want to use Data Validation to create a drop down list based on a list I have in a sheet. However, the list includes duplicates, and I only want the drop down to show each of the items once. Any ideas? LIST EXAMPLE: Fox Dog Cat Dog Rat Fox DROP DOWN TO CONTAIN: Fox Dog Cat Rat

I am writing some VBA that contains the loop: Do Until ActiveCell.Value = Empty - - - - Loop Unfortunately when the activecell value is "0", then "activecell.value = Empty" is true. How can this be correct? If there is a zero in the cell then it is not empty, it contains...

How and where does a sql statement go in Crystal? I found out the Expression Editor is a joke - that it's not meant for actual SQL Statements(from a document on crystal's website). Can anyone help me please? Let me know if you need more inforamtion to help me but I think it's straight forward...

I have been trawling around the internet for hours trying to work out this one, can anyone help? I have written some code that transfers a set of data from an excel sheet into *.csv file. I would like to be able to open it in using Notepad and then save it as a *.csv with UNICODE as the...

I have a presentation of 70 slides. For 69 of the slides the presenter has to press the mouse button three times before PowerPoint will move on to the next slide. For 1 slide it works the way I need it to, i.e. one click to move to the next slide. Is this a setting anywhere? I don't seem to...

I've set up some data validation on my spreadsheet that forces the user to select from a list of options for that cell. I want to run a &quot;Worksheet_Change&quot; macro when the value of this cell changes. The macro runs when the user types in a change but not when they select a different...

Please see the attached code: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = &quot;$N$206&quot; Then Range(&quot;$A$206&quot;).Select End Sub The code is attached to an excel 97 worksheet. When the user selects cell N206, I want to move their...

Is there any way I can create a custom format so that my cell is always in degrees celsius ?

I have written some code that exports calender information from outlook into an excel workbook. The workbook refresh's at set periods of time. The problem I have is when the macro re-runs it opens another execl workbook, so I need some code that will determine whether or not it is already...

Using Excel 97, I have set up a form that when a checkbox is ticked (= TRUE), then all other checkboxes on that form also become ticked (= TRUE). I need to be able to say..... For each CheckBox in MyForm CheckBox.value = TRUE I also don't know whether I need to declare &quot;MyForm&quot;, and...

I have a spreadsheet of information that I would like people to be able to view in Excel. I want to allow other users to query the spreadsheet using filters at will, however, I've just found out that when you protect a sheet filtering doesn't work ! I don't want to password protect the...

I have used option buttons and check boxes in an excel spreadhseet which work perfectly.... ...until that is the spreadhseet is protected. When protected it won't allow me to select then. Any help would be appreciated !!! Le

Here's the thing ! Column D has a list of names (the same name may appear several times, maximum 6 so far), Column J has an internal code and Column S has a percentage value. How can I look up a name in column D, and if the internal code is the same as the one I'm dealing with then I want to...

Hi Everyone ! I want to use the INDIRECT function to find a reference in another workbook, but I can't seem to get it to work when using paths. For Example: WorkbookXXX cell A1 has the entry: &quot;C:\My Documents\[WorkbookYYY.xls]Sheet1'!A1&quot; I want to put the value of &quot;C:\My...