I have a bunch of data that will keep changing. Each named range is arranged in columns on a separate tab. I have gotten far enough that I can add data to it ok but don't know how to set up the range in the first place. IE a named Dynamic Range???? So far I just have the range set up by naming it and using a pre defined number of rows. Dont want to leave it like that. Some day sooner or later it will be a problem and I would like to learn how to do it anyways.
I'm using Excel 97 so I can't use the built in method on naming a dynamic range that I have read about.
Thanks
Menessis
I'm using Excel 97 so I can't use the built in method on naming a dynamic range that I have read about.
Thanks
Menessis