Excel VBA Loop Question

[carcanfloat]

Hi all,
Trying to do the following steps in order.
1. write formula(A) into A1
2. copy A1 and paste value into A1
3. move to A2
4. write formula(A) into A2
5. copy A2 and paste value into A2
6. move to A3... and so on until A100

Thanks

[Leith Ross]

Hello carcanfloat,

Welcome to the forum!
To recap your request you want to replace the formulas in cells A1:A100 with their values, correct?

[YasserKhalil]

You can put the formula in the range you want without any loops
What formula would you like to put ??

Generally this is simple example

Please Login or Register  to view this content.

[carcanfloat]

Hi Leith,
Thank you, looking forward to learning and expanding my Excel skills.

Yes.

Here's the formula:

=COUNTIFS(census!$M$1:$M$272592,B4,census!$K$1:$K$272592,$D$3)

The starting cell is really D4 and i need it to copy and paste values until D1000.

I thought that with the COUNTIFS function and the large amount of rows that it's running through, that it would be faster to calculate one cell at a time and copy/paste value.

[YasserKhalil]

Can you attach sample of your workbook ..?

[carcanfloat]

I can attach screenshots, would that help?

[YasserKhalil]

Use my code and change the formula and the range .. and test it ..

[carcanfloat]

That worked! Thank you!

[YasserKhalil]

You're welcome. Glad I can offer some help