Recent content by mike101

y = 2E-21x6 - 4E-18x5 - 1E-13x4 + 4E-10x3 + 2E-06x2 - 0.0094x + 10.275 R2 = 0.8764 www.ripplewine.com/graph.xls <-- what I'm working with.

I have an input and a calculation which creates an output. However, it makes many digits with the decimal point. I just want to have the single digit before the decimal point, and 2 digits after the decimal point (i.e. 1.23) instead of what I have now (i.e. 1.234567788) do you know how to limit...

Unfortunatly... it seems Excel is giving me the wrong equation. I've entered it into my TI-Calculator, and I get the same results as I do with putting the equation it gives me in a VBA script and calculating... so I know that I have the equation right cause they check out with each other...

Thanks that worked.

I have used my data to make a graph and a trendline. Excel has given me the equation in this format: y = 2E-21x6 - 4E-18x5 - 1E-13x4 + 4E-10x3 + 2E-06x2 - 0.0094x + 10.275 I am trying to make this work in VBA format as a calculation where I can input x, and get the value of y. I don't...

I am using a for loop to open and convert data. Workbooks.OpenText Filename:= _ &quot;C:\Documents and Settings\All Users.WINDOWS\Documents\sciencefair\Wind data\06\&quot; & date8 & &quot;\&quot; & i & &quot;.dat&quot;, _ Origin:=xlWindows, StartRow:=1...

Hmm... I'm wondering if perhaps the problem is connected to something else in my code then. Here is the entire code for the sub to open up the files, cut info from one file, and paste into the next file Sub Generate_files() Workbooks.Add ActiveWorkbook.SaveAs Filename:= _...

I'm still getting a Run-time error &quot;1004&quot;: Method 'Range' of object &quot;_Global&quot; failed using that conversion.

In my script, I'm trying to have data grabbed and placed in excel as a list. Range(&quot;A1&quot;).Select ^ This works perfectly fine, but I want it to be a list, so I've substituted 1 with a variable, and the variable is the number I want it to be in. The variable is already declared, and I've...

Is there any way to convert a Fortran script so that it can work in Visual Basic? Thanks.

For Counter = 1 To 5 Y = Counter * 3000 Range(&quot;E&quot; & Counter).Select ActiveCell.FormulaR1C1 = &quot;=R&quot; & Y & &quot;C[-2]&quot; Range(&quot;F&quot; & Counter).Select ActiveCell.FormulaR1C1 = &quot;=R&quot; & Y & &quot;C[-4]&quot; Counter = Counter + 1 Next When I...

Awesome, thanks. I would like to try to figure out how to have it continue to loop until it finds cells with no data. Right now I just have a place-holder to do it 5 times and then quit... but I'd like it to keep going till it detects a blank column. Any ideas? thanks again!

I am trying to take the 2999'th value for the B column and the C column and place them in D1 and E1... then go to 2999*2 for D2 and E2, etc. Below is the code I have. Sub Macro1() Dim Counter As Integer Dim Y As Integer Counter = 1 Y = Counter * 2999 If (Counter < 5) Then...

When I open up a data file and have Excel seperate the data, it works fine. However, my problem is that this data file was created and formatted to be printed out, so at they determined how many lines would print out in a page, and on each page put a header that looks like the following: USE...

I am new at VBA. I am working with data for a science fair project, and the data is very very very precise. The data is taken every .02 seconds. I do not need all of this data. Here is an example line of data: &quot;2003153 21:00:00.000 284.00&quot; I would like to have VBA somehow...