Search results for query: *

I have been searching for a way of somehow loading/registering a DLL file to the Excel VBA Reference Library through a VBA routine. Does anyone know of a way to do this? Somewhere out there is a Rocket Scientist who must have the answer. Much appreciated and thanks. Nigel

If I try to output the statement: ActiveWorkbook.ActiveSheet.Cells.SpecialCells(xlFormulas, 23).DirectPrecedents.Address ...to a range on a sheet; if there are a lot of formulas and precedents I only ever get the first 255 characters. Why is this and how can I get the whole lot with out...

Anyone know how to build a list of built-in number formats in a workbook and not just those that are being used? Thanks.

Andreas, This could be done with code but over the years I have learned that the quickest and simplest way, once you've done it a couple of time is the following. Replace all the "=" with "#=" to turn the formulae into text and then create a copy of the sheet and in the...

Greyhound1 The only way to do this is via VBA. Say you have a workbook with two sheets in. One is called "DataSheet" which holds your cells containing the text where you want to hunt down words and underline them, and the other is "ListofWords" which contains cells holding...

...that I see on the status bar when Excel is calculating and display it instead on a form via a progress bar that updates in real-time and then disappears once calculation is complete?

What OS are you using? Could it be that Office was installed when a different account was logged on and so although the machine side is available, the user side appears to be missing so that it is prompting you for the install CD? How about just reinstalling while logged on as yourself?

If you have a fixed period probably the simplest way to do this is to create a series of rectangles whose width is prorata'd according to the season against the total period and arrange them accordingly. Group them and then save as a export to a jpg format. Then just format the chart area...

I am trying to tell excel to go back to where it cam from and then get the row and column values and go to another worksheet and only calculate a range based on those row and column values of the original cell.

If I am in cell A10 in a sheet and move to an adjacent cell either by arrow keys, return key, tab key or by selecting another non-adjacent cell with my mouse; how do I pass the address of the cell I am leaving on to a variable. Many events seem to only look at the target cell but is there one I...

If I am in cell A10 in a sheet and move to an adjacent cell either by arrow keys, return key, tab key or by selecting another non-adjacent cell with my mouse; how do I pass the address of the cell I am leaving on to a variable. Many events seem to only look at the target cell but is there one I...

After any change to a sheet or a chart what VBA method may be used to determine if any change has been made to said sheet or chart in order to call a routine?

I have a folder that contains various file types. From Excel I want to be able to loop through the folder opening only txt files and importing their contents to a workbook. How do I do the looping through the folder looking for only the txt files bit?