My VBA is horrible and reading these messages has gotten me thinking, would
this work to save a sheet that is a series of TRUE/FALSE named cells with a
couple of named cells that have a number?
I ask because a file I use has one sheet that helps populate the rest of the
workbook and it is a little hefty at 20MB. If I could save the named cells it
would cut the size down immensely and would require me to transport the saved
file between locations via email.
And if possible would the location of the named cells matter? I mean would it
screw the VB up if the location of a named cell was moved elsewhere on the same
sheet?