Recent content by Jock1970

Thanks for your response Gruuuu - I had thought of that, but surely I would still end up with white margins.

I have an excel spreadsheet which is printed onto coloured paper to form part of a published document. A pdf version gets posted on our website, but we can't find an easy way to colour the pages within the pdf copy so that it looks the same as the paper version. Any tips ?

Hi Goeff, Sorry - it looked different to me, but I don't have your expert eyes. You have triumphed again - there is protection on the worksheets and when I remove this it works perfectly in Excel 97 too. I can't understand why it works in 2003 with the protection on, but not in 97. I'll have...

Goeff, I tried a ' at the start of the ".Interior.ColorIndex = -4142" line. I still get an error but it's the line 2 down from before that's now highlighted. It says Case "Not Started" .Rows(c.Row - OSet).Interior.ColorIndex = 2 It seems strange that it did not seem to find...

Hi again Goeff, It still works perfectly in mine, and still comes up with the same error in 97 I'm afraid. Any more ideas ?

Goeff, Sorry, but I have a problem now which hopefully you can help with. Your solution above worked perfectly and everything does what it should now - but only on my PC. I am using Excel 2003. I tried showing a colleague how the sheet should be used on their PC (in Excel 97) and as soon as...

Goeff, Thankyou very much - that works perfectly. Cheers !!

Hi Goeff, In answer to your questions :- 1. The formula in column J is "=VLOOKUP(B9,'C - Resurfacing'!$B$7:$H$23,7,FALSE)" so is a direct look-up to a single cell in another worksheet. A 1 to 1. 2. No, the formula is permanent. The resultant value changes autiomatically as the donor cell...

Thanks Geoff, that's a step forward but it's still not exactly what I need. The code above changes the fill coloour of the cell with the text in it (column J in my case). I want the cells in columns B to G to fill dependant on the value in J. What changes are required to the code to achieve...

It is not impossible, but it will require a macro (AKA Code AKA VBA). These are the responses you have likely seen in other posts." As it seems to be impossible by simpler means, could someone help me along teh VBA route ? As I said in my first post, I have read the earlier threads, but I...

Hi Goeff, thanks for the reply. I used CF for the first 3 criteria and it works perfectly but obviously is no use as 3+1 is the maximum and I need 4+1. Re. "You will not be able to use numeric formats as you have text rather than numbers" - I could convert the text in my Column J to a numbers...

This seems to be quite a common question on here and before anyone jumps in with a 'read the previous posts' remark, yes - I have already. Some of the answers given previously are way over my head, but I don't think anyone who asked before has been trying to do the same as me (format a range of...

Hi, If I understand your question correctly, what you need to do is 'Alt + Return' which forces a new line within a cell. Cheers, Jock

I have several spreadsheets which I use with 'autofilter' to view specific records. Usually when I filter on any column text appears in the bar (immediately above 'start' in the taskbar) saying something like '15 of 279 records found' - i find this very useful. A new spreadsheet created recently...

Thanks Kenwright, that's exactly what I wanted ! Cheers, Jock