View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt S Matt S is offline
external usenet poster
 
Posts: 112
Default Concept question re ranges and calcs

I have a macro that does a ton of calculations for me. I am looking to
update its capabilities by giving it a user-interface and more flexibility.
I am therefore moving out of the realm of doing calculations knowing which
column contains what data. So, I now have the situation where columns will
be deleted based on user-control and data may or may not be where I
originally had it.

I'm thinking the best way to handle this is to define columns of data as
ranges prior to deleting other columns around them and then doing the
calculations on the ranges. Does anyone have some input on if this is the
most efficient way to do this?

Thanks as always,
Matt