ExcelBanter - MACRO in EXCEL

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - MACRO in EXCEL (https://www.excelbanter.com/excel-programming/376497-macro-excel.html)

Brent

MACRO in EXCEL

How do i create a macro where the selection changes each time? I want to
create many different charts from the same sheet.

Tom Ogilvy

MACRO in EXCEL

Dim rng as Range
set rng = Range("A1:C30")

now use rng in your macro commands.

--
Regards,
Tom Ogilvy

"Brent" wrote:

How do i create a macro where the selection changes each time? I want to
create many different charts from the same sheet.

All times are GMT +1. The time now is 07:29 PM.