Hi there, I am trying to define a number of ranges in different sheets using VBA I am using the follwoing syntax but I am getting a 1004 error Code Private SubYou can use 2 different syntaxes to define the range you want to work with Syntax #1 ("Cell1") This is the minimum you must include for purposes of defining the relevant cell range As a general rule, when you use this syntax, the argument (Cell1) must be either of the following A string expressing the cell range address The name of a named cell range When naming a range, you Additionally, Excel's Define Name feature allows you to create a name for a constant or formula Make a named range by using Excel Name Manager Usually, the Name Manager in Excel is used to work with existing names However, it can help you build a new name too Here's how Go to the Formulas tab > Defined Names group, click Name Manager
Excel Vba Tutorial Named Range Arrays
