Need help applying a formula to all columns that have heading "Adj Close"

[aad401]

Hey,
I am trying to write a code which applies a formula that calculates the amount of change in the values of a column. I needed help on how I can apply this to all the columns that are headed by "Adj Close."

The current code is:

Please Login or Register  to view this content.

[gmk]

aad401

Seems like you have posted twice on the same question.

Try something like this

Please Login or Register  to view this content.

hth

gmk

[aad401]

Hey thanks, that worked out well. Would you happen to know how to edit this code so that the formula can be applied to all of these columns.
EX: column "E" and "H," and a variable number of other columns also have a set of values in them. How can I change this code so that I can get the corresponding amount of change?

Thanks

[gmk]

aad401

Would you happen to know how to edit this code so that the formula can be applied to all of these columns.

Not clear what you mean. The code, as requested, will apply the formula in "B" lastrow + 2 to all columns which have the header 'Adj Close' not just cols E,H and K.



gmk




If this is the answer you require please remember to mark the the thread as solved and if you feel it is warrented then add to my reputation by clicking on the star at the bottom of my reply.

[aad401]

I apologize for the mix up. To be more clear, the current formula simply pastes the calculation for the first column into all the other columns labeled "adj close" rather than recalculating the change for the entire column. I was trying to get a new calculation for each column.

Thank you very much for all your help. It is much appreciated

[gmk]

aad401

This will reproduce the requested formula in all columns headed 'Adj Close' and adjusts for the possible varying number of rows in the target column.

Be careful if you run the code a second time... it will recalculate the last row in each target column therefore a rerun will include the previous result. Test it to see what I mean.
If you need the previous result to be removed the code will need to recognise it as a result somehow. If you do need this come back.

Edit .... Is the result row number fixed as in your first outline i.e. row 15 or variable?

Please Login or Register  to view this content.

hth

gmk




If this is the answer you require please remember to mark the the thread as solved and if you feel it is warrented then add to my reputation by clicking on the star at the bottom of my reply.