Search results for query: *

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

Hi Guys, I'm sure this must have been asked on here before but my search didn't reveal any similar questions. I need to count how many records have certain criteria in 2 columns e.g. how many records have the word "Church" in Column A AND the number "1" in Column E. I can't see how to double...

Thanks for your reply klklkl, I found earlier today that if I changed the macro security setting to medium (from high) it then asked whether to enable macros when the file is opened. Cheers, Jock

Hi Guys, I've checked the workbook and it is not shared. There are no 'conditional formatting' parameters other than those in the VB script above. This does however seem to apply to the whole worksheet - how do I change this ? (not that it is the problem as it also applies to the whole...

Hi Guys, Thanks for the suggestions. I'm at home now, and the file is at work - I'll try you're tips out in the mormning and see if they make any difference. Cheers, Jock

Thanks for you help anyway, Graham I appear to have solved the problem, but only by copying all the cells into a brand new spreadsheet then formatting the rows/column widths etc to mimic the original. The file is now only 49kb ! I have kept a copy of the original 12.5mb version. I would still...