Last row automatically equals fill down range.

Hey,

I've recorded this macro that requires me to fill down functions to the last row with data. Instead of adjusting the Macro manually to fit the data set, is there something I can insert in this code to make the range "B2:F35" automatically change to "B2:F'last row'"?

I was also trying to have a text box pop up and ask for the number of rows I wanted to work with, but I wasn't successful there.

Please Login or Register  to view this content.

Any help is appreciated and thanks in advance.

Thanks a lot HaHoBe, that was exactly what I was looking for.

Hey @HaHoBe,

Quick question. I'm trying to apply that code to other sheets in my workbook and want to use the row count
From Row A in another sheet. I'm having trouble with the syntax to do this. Can you help me out here?

Please Login or Register  to view this content.

This formula is being applied to an active sheet "Compare" but I want to use the row count from either sheet "Varasto" or "FactSet"

Thanks so much.

Hey Holger,

Sorry for that lack of clarity, but that was what I was looking for.
I was trying to target the 'Varasto' sheet with activesheet and other stuff which wasn't working.

Thanks again.