vba script to calculate data across multiple columns

Hi all,

i have a rather large data sheet that i need to perform a calculation on by a fixed amount per column

i have around 300 columns of data, with around 600 rows, i have written this script which performs the calculation on a single column of data, but need to expand it to cover all columns of data

Please Login or Register  to view this content.

here is a sample of my dataset

4.7239 4.7239 4.7239 2.3021
COmpany1 Company2 Company3 Company4
-203222 300000 2000000 -4443322
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

Hi pchappo

Welcome to the forum....
In future please view the forum rules before posting. Your post does not comply with rule #3.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window.

Can give this a go...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hello
Can you post sample of your workbook?

300x600 = 180000 calculations.

My advice would be to load entire range into array, perform calculations in memory and write array back to worksheet.

@ bakerman2
So this stores calculated value in array...How to populate range with arr values?

Please Login or Register  to view this content.

Edited...Nope Not storing used range!!!

something like this.

Please Login or Register  to view this content.

@ bakerman2...
Why does this only store the first column values in the code in post 7?

Please Login or Register  to view this content.

Edited...How bout this....

Please Login or Register  to view this content.