Trying to name a range of cells as "database" in a macro
Posted on 2001-07-26
When I try to name a range of cells as "database" in a marco sequence, Visual Basic gives me the following result:
ActiveWorkbook.Names.Add Name:="database", RefersToR1C1:= _
My problem is I want to use the sequence with various different workbooks. This macro was created with an imported document named '2521' It seems if I want to use the macro with another document, Visual Basic still returns the information based on the earlier document namd.
I did select "relative reference" when I used the macro but that doesn't seem to solve the problem.
I would very much appreciate any help you could provide.