Macro to create a Dynamic named range.

[Hilton1982]

Hi all,

I need a macro to create a Dynamic named range and I don't now where to start?

I have a userform that run a report on filter data therefore the amount of data on the report will change according to the filtered data. After the report has been generated a macro needs to run to make a dynamic named range for Column C row 7 going down and call it TotalTime thereafter i will have a code that will SUM the TotalTime.

Can anyone please assist me with the macro code?

Thanks,

[Sean Thomas]

why do you need a macro to do this?
are you creating a new sheet first for this data to be added?
why not already create the dynamic range and name it, then add the data on each empty row in column C and the range will expand. Thats what a dynamic range does.
Remember you can only have one range name the same in a workbook or else you will get errors.

[Hilton1982]

Sean,

Every time a run the report it goes on a new workbook and then from there i need the named range so that i can add formulas and make a chart ect.

This will be basically on click and the users should be able to send the customer a report with the correct data.

[Sean Thomas]

Hi try this

Please Login or Register  to view this content.