Average Coding in VBA

[ParkerExcel]

Hey guys,

So what I'm trying to do is condense a bunch of data into a smaller file. I need to take an average of the data over every three minutes and associate it with other data. I was able to write a working code that allowed me to accomplish this but what i'd like to do is have it prompt me for a number of minutes and use the number I type in to determine the range over which to take the average. Here's what I have before.

Please Login or Register  to view this content.

and here's what I'd like to do

Please Login or Register  to view this content.

Only I don't know the coding to accomplish that. Any ideas?

[Domski]

Please use code tags when posting code to the forum per the forum rules.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).

Dom

[jetted]

Did you try something like this

Please Login or Register  to view this content.

[ParkerExcel]

Good Idea, Denis, but it was a no go. It came up with run-time error "1004"; Application or object denfined error.

[jetted]

Hi Parker

The only difference I could see is
Minutes the first one was recorded at -1399

Please Login or Register  to view this content.

The new minutes if 3 minutes
minutes=-1439

Please Login or Register  to view this content.

Your best bet is to attached(spreadsheet) a sample of what you want done