Search results for query: *

Thanks Mrmovie for that info. It works well but only on the first worksheet not on the active worksheet. Any other suggestions? Thanks again!

I use a macro to replace formulas with values, I need to modify it to run on the active worksheet only.Please help, I do not understand visual basic. Here is the code: Sub FormulasToValues() ' ' Replace all formulas with values ' WCount = Worksheets.Count For i = 1 To WCount If...

OK my mistake, I did say I'm not very good at math. Thanks everybody for your assistance!!

Here is the page I got the formula from. It is in the section on "Curvature of Curves" section. http://www.math.cornell.edu/~dwh/papers/EB-DG/EB-DG-web.htm

OK here it is written out as best I can 4pi^2R/[H^2+(2PiR)^2]

I have copied the text from the document. "If R is the radius of the cylinder and H is the height of one turn of the helix, then the curvature of the helix can be computed to be 4?2R/[H2+(2?R)2]. In the case of R = 1m and H = 10m, this gives us r = 3.533m."

I have just noticed that the Pi symbol in the formula has changed to P. Sorry if this has confused anyone.

How do I enter the following formula in a cell in Excel. 4p ² R/[H²+(2 p R) ²] Where R=1 and H=10 the answer should be 3.533. I cannot get this answer, but I am not very proficient at math. Any help would be appreciated. P.S. The formula is for calculating the curvature of a helix. I intend to...

I recorded this macro in Excel to convert dates in column A(23/4/04) to text as the file is linked to an Access database and the dates appear as a number, i.e. 38100. The macro works OK but converts the text from 23/4/04 to 4/23/2004(the cell format changes to text OK). How can I do this...

Ok I've worked it out. For information the column heading in excel had 3 spaces before the heading text. If I linked the table without checking " The first row contains column headings" box all was OK. I then deleted the spaces before the text in the heading and all was OK. Table is now linked...

The first record is all text. The column is formatted as text.

I am trying to link an excel table to access, it works OK but one field loses all it's data. I have tried everything I can think of to rectify this problem but no luck. The cells in the excel table are formatted as text i.e.(addresses) I'm sure the answer is very basic, but I am new to access. Help

I think I have found the problem! The column in Excel has a formula. If the cell is blank the link to Access has a "#NUM!" entry in the cell. This is causing a datatype mismatch. When I run a query with "between #1/1/2003# and #31/12/2003#" as the criteria it runs OK. When I...

Hi I am new to using Access. I have an Excel table linked to Access. I have setup several queries and reports with no problems.I am trying to set up a Parameter query using date range " between [start date] and [end date]" but I get a numeric overflow error. I think it may be because...

Hi Mouse cursor is not responding on booting Win98SE computer. Have tried another mouse that is known to be working. Have reinstalled drivers etc. but no response. Could this be a motherboard problem?

When I close an Office 2000 application I get the error message "Excel has encountered a problem............ and will close....." The same happens in Word. I have tried reinstalling but no joy. Anyone now the answer to this problem?