Macro speed improvement

[YounesB3]

Hi, I'm looking to improve the speed of a macro by regrouping different actions into one.

Here's a list of stuff that I think could be potentially done, but I'm not sure how:

1 - Autofill destination:

Please Login or Register  to view this content.

I tried the following:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

None worked.

2- Offset selection:

Please Login or Register  to view this content.

I didn't try anything, I'm not sure how to select the different offset cells into one. Is it possible?


3- Formulas with find blank in different cells at the same time:

Please Login or Register  to view this content.

Again, I didn't try anything and I'm not sure how to select the different find blank cells at the same time. Is it possible?




Thanks for any help provided.

Note - Cross-posted here: http://www.mrexcel.com/forum/excel-q...ml#post3475018

[JBeaucaire]

Perhaps:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

Explain in words what you're trying to do in the second scenario, do not refer to vba in your explanation.

[YounesB3]

Perhaps:

Please Login or Register  to view this content.

This seems to work, but still acts kind of like 2 copy-paste, which doesn't improve the macro speed

Or:

Please Login or Register  to view this content.

This copies line 52 as value and also still acts kind of like 2 copy-paste, which doesn't improve the macro speed

Explain in words what you're trying to do in the second scenario, do not refer to vba in your explanation.

My macro works in the 3 scenario, I just want to regroup some of the lines to make it faster. Maybe it's not possible though.


As for the second scenario, what I'd like to do is to select the different offset at the same time. Something like this :

Please Login or Register  to view this content.

[JBeaucaire]

Is row2 all formulas? if so:

Please Login or Register  to view this content.

Second problem was not described in words, so can't really visualize WHAT you're doing. You may be right, separate ranges frequently must be dealt with separately.

[YounesB3]

Is row2 all formulas? if so:

Well cell A52 and BH52:BR52 are all formulas yes.

Please Login or Register  to view this content.

This one seems to work like the previous one as well, thanks!

I'd like to know though if it's possible to do both line 2 and 3 at the same time? Weither it's my code (autofill destination) or the 2 other options you provided?


Second problem was not described in words, so can't really visualize WHAT you're doing. You may be right, separate ranges frequently must be dealt with separately.

Sorry about that. The reason I do a find from cell B52 is because every time I run the report, the line will be different. From this line though (let's call it line X), I want to remove all data of line X and below for column B-1 (column A), column B+52, column B+53, etc. Hope it clarifies a bit.

Thanks for the help provided, it's appreciated!

[JBeaucaire]

Lines 2 and 3 do need to be processed separately.