Q: Setting Sheet References

  • Thread starter Thread starter pinkpanther
  • Start date Start date
P

pinkpanther

I have a stupid question that I have not been able to find an answer
to. I am building a tool for others to use that uses worksheets and
charts. I have some calculations in the worksheet that affect the
presentation of the charts. Is there a way to refer to these
worksheet cells in VBA so the reference will move in VBA when the
users modify the sheet; because they will.

The first response is to lock the sheets, but if I do this the users
will complain that the sheet doesn’t meat their needs so I will have
to change the tool to everyone’s specific needs and this is what I’m
hopping to avoid in the first place.

So if I lock the sheets I’m going to have to modify to everyone’s
whims; if I don’t lock the sheets the code will no longer work and I’m
going to have to modify to everyone’s whims.

Any help would be appreciated,
Larry
 
I have a stupid question that I have not been able to find an answer
to.  I am building a tool for others to use that uses worksheets and
charts.  I have some calculations in the worksheet that affect the
presentation of the charts.  Is there a way to refer to these
worksheet cells in VBA so the reference will move in VBA when the
users modify the sheet; because they will.

The first response is to lock the sheets, but if I do this the users
will complain that the sheet doesn’t meat their needs so I will have
to change the tool to everyone’s specific needs and this is what I’m
hopping to avoid in the first place.

So if I lock the sheets I’m going to have to modify to everyone’s
whims; if I don’t lock the sheets the code will no longer work and I’m
going to have to modify to everyone’s whims.

Any help would be appreciated,
Larry
Click to expand...

Larry,

Without more information your question is a little hard to answer.

However the short answer is no.

Once you have referenced a cell or range in VBA it wont move with the
cell.

One way, depending on your setup, would be to find the keyword in the
sheet that relates to the value you want to return

But without more information its hard to know what to suggest

Regards

David
 
Back
Top