Search results for query: *

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...

Hi all, Is there a mouseover effect in excel, ie replace one picture with another when the mouse hovers over it? 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...

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...

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...

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...

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

Hi all, Is it possible to insert a cell reference in between a text statement in one cell? for example, the following all in one cell: There is spare capacity of =C19 pieces between both banks of machines. Where the resultant is: There is spare capacity of 2005 pieces between both banks of...

Hi all I installed a free download for changing the appearance of windows including the login/welcome screen on HP home edition. I uninstalled the software and now any time I boot up I don't get the standard welcome screen that displays all the user accounts, I get the logon box that requires...

Hi all, I have a spreadsheet with a lot of columns dedicated to different calculations. The formulas yield results as you would expect but the problem arises when you need to print the data a discuss with others. It takes time to explain to all the formulas used to calculate each cell. In know...

Hi all, I am creating a vlookup table to pull read information from a named range based on the input value as per normal with vlookup. I am taking it a small step further in that the number used for my lookup_value is the result of a formula (..=IF(C2="","",LEFT(C2,6))..). I am getting #N/A as...

I have a listview (ListView1) whereby I want the selected Key value to appear in a textbox (Text1). I also need the subitem for the listview to appear in another text box (text2). I've tried several codes but being a noobie i'm not having much luck at the moment. Anyone got any similar codes or...

Help!!!! I'm putting together a dictionary of terms and keep getting a Compile error: User-defined type not defined for "itmX As ListItem". I have the microsoft scripting runtime library checked. How do I get rid of this error? My code is: Private Sub Form_Load() Dim dicX As...

Hi all, I've created a dictionary and need to get the key values displayed on my form at runtime. The dictionary was created as follows: Private Sub Form_Load() Dim def ' Create the variable. Set def = CreateObject("Scripting.Dictionary") def.Add "a", "Athens" ' Add keys and items. def.Add...

Hi all, I've been searching the net for a solution to this question with no success and as usualcome back to Tek Tips! I have a teaching program that uses a lot of different terms in each chapter. I would like to create a searchable glossary of terms with their definitions. Also, each term...

Hi all, I've been searching the net for a solution to this question with no success and as usualcome back to Tek Tips! I have a teaching program that uses a lot of different terms in each chapter. I would like to create a searchable glossary of terms with their definitions. Also, each term...

Hi all, I've created macros in Access that can be dragged onto the desktop (or other locations). Then without having access open the macro can be activated whereby it opens Access and performs the required task. Can this be done in Excel also? Thanks, Owen

Hi all, This is probably a really simple question.... I have a cell with a value, say value of C1 is 10. I need a formula to read whether the value in C1 is between 0 and 1000 and if so to return a value of 1, or else return a blank. I am writing the if statement as follows...

Hi all, I need to sum all the data in a column below the fourth row, ie Sum(A5:AInfinity) Does anyone know what AInfinity should be? Thanks Owen

Hi all I am using a dynamic named range (that I learned from GlenUK) to automatically update a graph of data points (see formula below). The figure I am updating is a calculated percentage, and if there are no figures entered to calculate it, then the cell returns a blank. To explain - the...