How to edit macro for auto-fill?

[toci]

I'm using 2 macros for auto-fill data and both work fine, but I have problem when I had only one row? Could you please give me some advise how to change these codes?

Thank you in advance!

Code 1

Please Login or Register  to view this content.

Code 2

Please Login or Register  to view this content.

[JBeaucaire]

How I usually do this:

Please Login or Register  to view this content.

[toci]

How I usually do this:

Please Login or Register  to view this content.

I am going to check this right now

[toci]

I am going to check this right now

I have 3 Columns for auto-fill (ET,EU and EV). Have a problem with this code on EU column? Any idea?

[JBeaucaire]

Please stop using the REPLY WITH QUOTE button. Use the REPLY button or the QuickReply box below. Thanks.

What seems to be the problem?

Please Login or Register  to view this content.

[toci]

The last one works well when I have only one row, but if I have more than one, it doesn't work. I need macro which will auto-fill formulas up to the last row. That is, if I have only one row, auto-fill it. If I have e.g. 100 rows, auto-fill Columns ET, EU and EV up to the end.

[JBeaucaire]

I don't understand the problem you're having. I use the code suggested, similar, over and over in macros daily.

The line of code that is setting the LR variable, be sure to use a column that will always have data in it for every row. I usually use column A. Do you need to change that to column A?

[toci]

My last 3 Columns are ET, EU and EV. In "ET" Column I have function =LEFT. In "EU" an "EV" Columns =VLOOKUP based on values from "ET". So, I need to populate data in that Columns. When I put your last code in macro, it fills me only range ET2:EV2, and my range is e.g. A1:EV150? Therefore, macro doesn't want to fill down other cells.
Column A is quite good for condition as I have always data in that column.

[toci]

Please Login or Register  to view this content.

This is my macro I use on daily basis. How to edit it so when I have only ONE row in range A1:EV2 to auto-fill it. With this code (macro), when I have only one row, auto-fill function (Offset...) is going up to last cell in excel file and than i need do delete it manually. I hope so that now is a more clearer.
Thanks for all your efforts!

[JBeaucaire]

I suggested you change the LR line of code to use column A, but in your example above I still see you have it set to "ET".

[toci]

I've changed like this:

Please Login or Register  to view this content.

But still nothing. It populated only range ET2:EV2.

[JBeaucaire]

Maybe add a popup after the LR

Please Login or Register  to view this content.

Would be interesting checking different columns until you find the one that actually finds the REAL last row. The code is correct, I haven't seen your data, but I'm guessing it's not what you think.

[toci]

I've edited a little my Report, and you can check this example. As you can see macro doesn't want to fill down all cells in Column G.

[JBeaucaire]

Your version of the full macro had you trying to first copy down a formula you hadn't even inserted until much later in the macro. Must do things in the correct order.

Please Login or Register  to view this content.

[toci]

Yes, this is what I need!
Thank you very much for all efforts that you put on this problem!

[toci]

Sorry, but one more question, please. :D
I've attached the example.
As you can notice this table has blue-white Style. When I run macro, how can I get the same Style in Column G ( blue-white, blue-white and so on)?

Once more again, Thank you!

[JBeaucaire]

Please Login or Register  to view this content.

[toci]

Thanks a million!!!