Search results for query: *

Thanks Guys. The last two methods work (using conditional formatting to hide values below 700 with John's idea). I was working on the Row() and Indirect() idea for a while. I think it would work but was having huge problems trying to solve it. Learned a lot about row and indirect functions in...

Hi all. I have a column of numbers that I need to sum in the following way. Column B should sum all numbers in column A that are on the same row or preceeding rows. For example from the list below, B1 would sum as 100. B3 as 500 etc. Is there a formula that can do this so that I don't have to...

Sounds a little too advanced. Thanks Geoff.

Hi all, Is there a mouseover effect in excel, ie replace one picture with another when the mouse hovers over it? Owen

Thanks all. I've set up a rule that mails me when I mail the wrong person. It doesn't solve the problem but at least i#ll know when it happens!

It's a global contact list, not a personal one. I don't have control over who is on the list. Owen

Hi All, Does anyone know how to block sending a mail to a specific person? We have several people on our address list with the same surname and first name and the wrong people are frequently getting sent sensitive emails. If I can set up outlook so I can stop block sending mails to specific...

It has worked. The information I'm searching for is actually in column B so I needed to change the reference from column A. Thanks John

Hello John, Sorry for the delay in replying. I am getting the following error: Runtime Error 91: Object variable or With block variable not set I've got the following code: Sub ConsolidateFiles() Workbooks.Add TargetBook = ActiveWorkbook.Name Set fs = Application.FileSearch With fs...

My code is..... Sheets("Detail").Select Rows("82:89").Select Selection.Copy Windows("Summary.xls").Activate ActiveSheet.Paste Range("A9").Select

Thanks John Are all 66 files in the same folder? Yes Are there other excel files in the same folder(s)? No Are the column headings/column order the same in each file? Yes Owen

Hi All, This query may be a little too advanced for this forum but here goes anyway! I have 66 Excel files each of which contains information I need. I need to copy it from it's current file to a new worksheet, pasting from each file I open. The data I need is identified in the spreadsheet...

Yes Skip always the same number in every workbook as it's a cost account code which I'm hoping will make it easier!?! John - I'll repost. Thanks Owen

Hi All, This query may be a little too advanced for this forum but here goes anyway! I have 66 Excel files each of which contains information I need. The need to copy it from it's current file to a new worksheet, pasting from each file I open. he data I need is identified in the spreadsheet...

Fair point Chris. I've already started to look at ways of doing this - making the sentences shorter/tables larger etc and then altering the text size to see how it looks. Owen

Thanks Fendal. The one problem with what you have above is that when I go to View..Text Size..Largest on my browser window all the text increases size. I need the text to be unchaved - a funstion something lie.. style="font-size:15" .. but this won't go inside the javascript in the location...

Hi all I have javascript that does the following: when the user puts the mouse on an image, text is shown in a specified location. Problem is I cannot modify the size of the text. I need to set it to a certain size to prevent surfers from messing up the look of the page by increasing font size...

Thanks Vragabond!

Thanks - works perfect!

Hi all, I have several images on my webpage set as hyperlinks. The effect of the images are being ruined by the blue/purple decoration around them. I can remove text decoration no problem. How can I do it for images? Thanks Owen