Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Francisca Perez   on Aug 09 In MS Office Category.

  
Question Answered By: Rayner Fischer   on Aug 09

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?

Share: 

 

This Question has 10 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Save a single sheet as a separate file Or get search suggestion and latest updates.


Tagged: