Search results for query: *

Neat! EvLer, If the number is greater than or equal to 1 ( or less than 0.1) how should it be rounded? For example, does 1.12345123451 get rounded to 1.1234512345 (10 digits after decimal) or 1.123451234 (10 significant figures) ?

PHV, Slick! Wish I had thought of that. Thanks, Walter

What is a good method of calculating derivatives in Access (or of calculating anything that depends on multiple rows of a table.)? I have a table of phase ([φ]) versus frequency (f), and I need to calculate d[φ]/df, the group delay. Here is a sample: ID f [φ] 11 3.045...

Irin, Is it that you want the labels of the split out pie chart to show percentages of the split out population? It may be possible to do that, but I do not see how. Would it be an acceptable work-around to make a second pie chart of the split-out data only? Best Regards, Walter

Irin, I think that Excel will split out any sectors you like to make a second pie chart. From your last post, you have a table like OnDrugs1 20 OnDrugs2 10 OnDrugs3 3 NotOnDrugs 67 (In this case, the sum is 100, but it need not be.) In Excel 2000, it works...

Irin, Sorry not to respond sooner. Work has been very busy. For the 1st part, can you see a way to summarize the data again, using the COUNTIF function? This time the range would be the indicator column, and the condition would be "0" for one row and "1" for the other. For the second part, I...

Hey Irin, Check out how the COUNTIF function works. It has two arguments. The first argument is a range of cells, and the second argument is a value or a condition. The function counts the number of cells in the range that match the condition. In our case, the range is the helper column...

Irin, An example is at http://www.geocities.com/straight_manus/TempOfficeFiles/Pie.zip or http://www.geocities.com/straight_manus/TempOfficeFiles/Pie.zip The first sheet has fake data on it, and the second has a summary and a pie chart. Hope this helps, Walter WC

Hello Irin, By "summary table", I meant a table that summarizes the data; it is not a special feature of Excel. You can put it on another sheet, if that is convenient. You can even put it in another workbook, although I don't recommend it! I would use 2 columns for the summary table. In the...

jryan3, You can use for ... next to step through all of the hyperlinks in the worksheet. Option Explicit Sub CheckHyperlinks() Dim oWB As Workbook Set oWB = ActiveWorkbook Dim oFS As FileSystemObject Set oFS = New FileSystemObject Dim oSh As Worksheet Dim...

t16turbo, Sorry, I forgot clean-up again. ... Set oOldSh = Nothing Set oOldWorkbook = Nothing Set oNewSh = Nothing Set oNewWorkBook = Nothing End Sub Best Regards, Walter

Hello t16turbo, I would try recording the act of copying, pasting, and saving with the macro recorder. The resulting code could be modified to fit your application, maybe like the following. Option Explicit Sub SaveWorkSheets() Dim oOldWorkbook As Workbook Set oOldWorkbook =...

t16turbo, I'm just guessing here, but I've had various trouble with Excel after workbooks became to large: too much data, too many charts, too many formulae or user defined functions. Recently some discussion of this occured in thread68-947957 If you like, you can have the macro delete itself...

As for printing, why not use the VBA macro recorder to make code, and then modify it? Best Regards, Walter

vbab, Good start. Now to follow Uncle Mike's advice, Option Explicit Sub LotCalc() Dim myVal As Long Dim i As Long Dim iRemainder As Long Dim nLot As Long 'Const nMin As Long = 0 'Const nMax As Long = 9999 myVal = InputBox("Input a number between 0 and 50,000") Select Case myVal...

...also WinDiff may be useful, if you have it WC

Goot, The method I described works if the button was created with the Control Toolbox Toolbar, but not if it was created with the Forms Toolbar. In the latter case, get the Select Objects tool from the Drawing Objects Toolbar, select the buttons by dragging a rectangle over them, and delete...

Maybe this is useful. If you manually embed the Media Player in a worksheet, then 1. Get into design mode. 2. Select the embedded Media Player. 3. Display its Properties. 4. One of the properties is named something like "Property Page". Click on the "..." next to this property. A form opens...

You can play something from the code using oWmp.URL = "C:\Windows\Media\chimes.wav" but replace my "chimes" path with the appropriate path or URL for what you want to play. Now trying to figure out how to activate the buttons for manual play. As a workaround, you could put your own buttons...

Very glad it worked! Walter