LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having a repeated concept ones Maracay Excel Discussion (Misc queries) 7 December 31st 09 02:52 PM
concept of syntax hamed Excel Discussion (Misc queries) 3 October 24th 07 10:25 PM
One more question pay calcs using [h]:mm format for time worke Rufus Excel Discussion (Misc queries) 4 July 25th 07 10:10 PM
Help with basic concept DTTODGG Excel Discussion (Misc queries) 0 December 8th 05 04:36 PM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"