macro generating chart from square..

[srdreddy]

I want a macro which generates a chart from a square selection (any no of rows, colms) , located any where on a worksheet.


if we generate a visual basic code with macro wizard....it applies only to the area and location selected..when you generated the macro...


thanks in advance...

[Andy Pope]

You can use the Selection object rather than the specific range reference used when recording macro.

If you need more help post your recorded code.

[royUK]

Take a look at using CurrentRegion, this might help you define the range.