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

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

$$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

$$Excel-Macros$$ Named range in macro

Hi friends, I am using XL2003. I am having trouble using a named range in a macro, even after refering the Help. The named range lives in the active workbook. My code is this: Private Sub Worksheet_Activate() With [CompNames] Set c = .Find(Range("A1")) If Not c Is Nothing T

$$Excel-Macros$$ NAMED Range

Hi All, I have selected A1 to A5 and given some name(In Named Range). Now I want to remove it. Anyone know how to do it??? Regards, Suresh --~--~-~--~~~---~--~~ -- Some important link