$$Excel-Macros$$ Named Range to Dynamic with VBA

Hi I would like to select an already named range and using a command button convert it to dynamic named range by columns and rows. Is this possible ? It would be a lot quicker than doing it manually each time. I failed to make a lot dynamic when I set them up. Appreciate your help, I am age

RE: $$Excel-Macros$$ Named Range to Dynamic with VBA

nd If Next N End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Cab Boose Envoyé : lundi 29 août 2011 23:39 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Named Range to Dynamic with VBA Hi I would like to select

Re: $$Excel-Macros$$ Named Range to Dynamic with VBA

mc & "))" End If End If Next N End Sub From: Daniel Sent: Tuesday, August 30, 2011 4:34 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Named Range to Dynamic with VBA Hi, Be cautious with this macro and keep a copy of your workbook. Look at the attach