Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
using the same range name on different worksheets in a workbook
I'm writing VBA code that performs actions based on the names of cells in a
worksheet. I'm building an application that has multiple worksheets in a workbook, and I have written some VBA code in a general module that I would like to be able to use in each of the worksheets. Part of the code performs actions based on the Range names of certain cells in the worksheet. Since I would like to be able to use this same code to perform the same operations in the various worksheets, I would like to be able to create the same Range name to corresponding cells in each workbook, so the code will perform the same actions in each of the worksheets. (I need to assign Range names because the "corresponding" cells aren't always in the same Row). However, I have noticed that if I try to use a Range name in one worksheet that has already been defined in another worksheet, it won't let you do it. Is there any way I can give cells in two different worksheets the same Range name, so the same VBA code can be used to perform the same operations in the different worksheets? Thanks in advance, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook | Excel Discussion (Misc queries) | |||
Create New Workbook from Worksheets in One Workbook | Excel Discussion (Misc queries) | |||
Sum same cell/range of multiple worksheets within a workbook... | Excel Worksheet Functions | |||
How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) |