Need macro to export to excel with dynamic number of rows

[#1]

Hello Friends,

Is anybody have the macro to export excel, in the Chart number of rows will be dynamic.

for example today the number of rows will be 100 and tomorrow it will be 110 rows and the next day will be 70 rows.

I have macro that is static only it will paste it based on hard coded values, is anyboady have the sample code.

Thanks in advance,

Chriss