Re: $$Excel-Macros$$ Defining Name Ranges in Excel for different selection region using VBA/Macro

2016-02-03 Thread Paul Schreiner
First, you must decide if the "Name" for the "Named Range" applies for the entire workbook, or just the sheet.If it's the entire workbook, then if you are in another sheet, and refer to the Named Range, it will refer to the range on the specified sheet.If it applies to the SHEET, then you can ha

$$Excel-Macros$$ Defining Name Ranges in Excel for different selection region using VBA/Macro

2016-02-02 Thread Sandeep Kumar Baranwal
Hi Please note that I do not want to manually define name range for selected columns. Could anyone help me with this. The number of columns and rows are fixed for each name range separated by a constant width. For example: a name range is to be defined for selection $A$1:$B$10 Another name range i