Would arrays work better?

Hello,

I have written the following routine in VBA and I am looking for advice to speed this up, as it is taking a little time to run.

I'm thinking that because I have given instructions on a line-by-line basis, it is taking longer to run. Would it be better to replace the indiviual lines with arrays?

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time.)

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file. In this manner we can see if you are using formulae and why in some cases you copy/paste and in other cases you simply make one cell equal to another.

Hello AliGW,

Thank you for your response. As you can tell, although I've been reading posts, but this is my first time making one.

Thank you for making the change, I know for next time now

Hello Mumps1,

Thank you for the response, I have uploaded the Excel file

After you input your data, are you not just copying the last row and pasting it to the row beneath?

See if this makes a difference:

Please Login or Register  to view this content.

Hi Mumps1,

Thank you for looking at this.

I have simply copied/pasted the range from A to T and then inserted GasReadDate and GasRead into columns B and C. The formulae adjust automatically to the new row.