Recent content by FletchUK

We had a similar thing at our company about 12 months ago where one of our receptionists was getting loads of junk email. Then I noticed she had smiley icons in her outgoing emails and realised she'd foolishly installed the HotBar application. I don't suspect your exec would do such a thing...

Brilliant! Thank you very much Skip. Fletch

Hi all, I'm trying to create a lookup and I want the name of lookup range to be dependant upon the value entered into a cell. For example, if the user enters the name "Robert" in cell A1 I want the lookup to check the range I've named Robert. If there was only one name the obvious lookup is...

Sorted it! My colleague had entered a subtotal in cell BK285 (the bottom row) to calculate the cells in that row. I changed this from subtotal to sum and now it works as expected. Thanks for your help xlbo, much appreciated.

Thanks, your reply has led to some interesting experiments... - If we select the entire range a1:bk285 the final row (285) is not filtered and appears all the time regardless of the filter criteria. - If we do not select anything and simply apply the AutoFilter the same thing happens as above. -...

Hi All, A colleague has a problem in Excel XP which has completely stumped me! When she applies AutoFilter to a list the filter is not applied to the bottom row of data. We've formatted the row so it's identical to the ones above - no luck. We have even copied a row from above and pasted the...

Hi everyone, We all know that when you apply a filter to a Microsoft Excel spreadsheet the row numbers change to blue to indicate that filters have been applied. Is it possible to alter this so they change to red instead? Thanks, FletchUK There are 10 types of people; those that understand...

A couple of things spring to mind. You said you'd set up a custom paper size in page set up but have you... a) changed the orientation to Landscape and... b)set all margins to zero?

Hi Dwarfthrower Sorry for the delay in replying to your post. At the time I didn't fully understand stylesheets but I have just spent the last couple of weeks teaching myself CSS and I'm now wondering how I ever managed without it. Thanks for pointing me in the right direction. FletchUK

I have PrintPage button on one of my web pages which prints out the tables exactly as they appear on screen complete with borders etc. The problem is that although the borders look good on screen (they are white) they don't look so good when printed out (they are black). If I set up a new page...

Hi When I copy an Excel table and paste it into a FrontPage web page table I notice that the html code includes xl classes. Does this mean that only people with Excel installed on their machine will be able to see the table or do web browsers automatically know how to interpret xl classes...

Hi Loomah Many thanks for your help. The command button now functions perfectly, even when the worksheet is protected. Fletch

Does anyone know if it is possible to sort data in a protected Excel worksheet? I have created a sheet which has a command button which when clicked runs a macro to automatically sort the data into the correct order (it's a league table.) Everything works fine until I lock the worksheet (to...

Here's yet another option! Instead of having to use two single quotes ("'" & "'") you can use the ascii key code for a single quote. Try this.... 1) Create a blank macro 2) Paste this code into the macro: ' ' Insert apostrophe at the begining and end of each cell ' e.g...

If you decide to use the code route try this: 1) Create a blank macro 2) Paste this code into the macro: ' ' Insert apostrophe at the begining and end of each cell ' e.g. changes John Smith to 'John Smith' ' created by FletchUK 25/09/2002 ' Dim r As Integer Dim c As Integer For r = 1 To...