hey gang- I can't seem to make these ranges do what I want them to! Would someone mind taking a look at this macro and slap me with the right answer?
this defines the range name, and shows it in the Excel list, but for some reason, when I need to call the name from a different form,(i.e. to load a combobox on a different form) I get an error telling me the name is not valid.Code:Range("RegisterList").Select Selection.Resize(RegRowCount + 1, RegColCount).Select ActiveWorkbook.Names("RegisterList").Delete NewAddress = "=Register!" & Selection.AddressLocal ActiveWorkbook.Names.Add Name:="RegisterList", _ RefersToLocal:=NewAddress
help?




Reply With Quote