substracting matrix

[frezty]

hi all sorry before if this question look stupid cause i am just a non programing people but try to simplify my work. and thanks for anyone who answer this

so this is the case, i wanna make a button which when i click it, it will substract data in column "A" with data in column "B" and the result will be in column "A", replace previous data. and this both column have the same amount of data.
for now i use the code copy and pastespecial operation substract. and my code like this

Please Login or Register  to view this content.

but i still searching if there any more efficient way.

and i see matrix substraction. but the example is to difficult for me to understand cos i dont understand which column they try to substract( i don't see any set for specific range).
so is my copy paste special still more efficient or matrix substraction better ? cos my current program run so slow in office 2016. and if matrix better can u tell me the program to substract column "A" with column "B" and the result put in column "A" replacing previous data?

thanx before

[AliGW]

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 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, I have done it for you this time.)

[xladept]

I think you're better off with your copy-paste routine rather than putting the array formula in every destination cell

[frezty]

oh i see. i also feel copy paste better cause matrix substract will take much program. ur answer make me more confident to use it. thanks
than can u give me advice how to make vba run faster? i already tried what i find in google like avoid use select, turn of event, manual calcualtion, avoid too much line use "," and ":" etc. but i still feel my program run to slow.
i use a button which when i click, it will do both copy paste substract and save workbook. but this took almost 10s more in excel 2016(before i use excel 2013). or is it better if i just throw the saving workbook program and do it manually?

[xladept]

In order to advise you, I need to see your code

[xladept]

Is your code similar to this?

Please Login or Register  to view this content.

And, thanks for the rep!

[frezty]

yup like that. only in code saving i use

Please Login or Register  to view this content.

(btw my file name is DATA )
is my saving way that make it run uneffieciently?

[xladept]

I'm not sure but maybe - try it my way and see