Search results for query: *

Thanks will do Steve

Thanks for your response. The report looks ok in preview i do not want to colour every other line. I just want the report to print out the way it is displayed on screen.

I am using conditional formatting in a report. It previews fine (Row text in red when tick box = true) when i print it doesn't print red text. I then placed a text box within the details section of the report and made the text red and the all the text on the report became red. Had this before???

Hey thanks that has pointed me in the right direction. Slight problem is the formula says action when the numbers are equel. When the numbers are equal i want it to say "OK". So in short i should have said Greater or equel to. Sorry this must sound really confusing, but the worrying thing is i...

Just starting to mess around with excel so sorry for the very basic question. In column A i have a list of numbers. Then in columns B,C,D,E i have some more numbers. In Cell 1F i want it to put the text "Action" if any numbers within B,C,D,E are greater than the single number in column A. If...

The type of data is simple text. Im using excel 2002 if it helps. I take it you mean the autofilter mode should be on? in cell A1 and A2 there are my column headings with the autofilters on. The dat is simply in column A first names and in column B are surnames.

Parameter is correct. It is the first filtered column. As i said it actually works but before it does work it produces this error message. Once i end the error messsage it then produces the correct data. Yes first autofilter is in column B. Column C also has an autofilter

Getting there i think. Still getting an error message before it selects the correct data. The message says: Autofilter method of range class failed. Appreciate your help on this one

No sorry about crossed wires. What i want to do is select an item from my combo box a simply use the selected items to filter the data.

Have renamed combobox1 to listbox Private Sub listbox_Change() Range("B1").AutoFilter Field:=2, Criteria1:=names.Text End Sub

Keep getting an object required error?

Could anyone point me in the correct direction to select the criteria for an auto filter via a combo box.

sorted it. thanks for the help

Not sure this is possible but here goes. I want word to restrict the number of fonts that are made avaliable to the user. Not sure how to do it as word seems to import every font it sees. Maybe a some code to make a new directory of fonts and copy only a limited selection. Not sure how to start...

Is it possible name a sheet directly from the data that is in a cell. I have a macro that produces a new sheet and an input box. The user inputs the new project name in the box and it is then transferred to cell A1. I want the sheetname to reflect the data the user has input in the box or in...

I want to show the current sheet name in cell A1. I guess this is possible if anyone can point me in the right direction