LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Creating a stack to push/pull ranges


personally i'll stick with my class...

further:
I'd always use Long and never Integer when working with rows.
In fact I almost never use integers. It may save 2 bytes, but slows
down the code (fractionally;) and you always have to think about it's
32k limit... In your worksheet stack it doesnt really matter if you
bounce at 32k or 65k...

I'd stay away from "personal.xls" as I think it should be reserved for
exclusive use of the user.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Antonio Elinon wrote in


kIC,

Thanks. I did notice your code can handle multiple types. My point
was to suggest that personal.xls can implement the stack and thus it
is limited to strings only, therefore the need to use Range(label)
after popping. On exit from Excel, personal.xls can be saved and the
stack will still be operational with other macros in personal.xls

 
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
Push Down Stack ? dhstein Excel Discussion (Misc queries) 3 July 27th 09 03:17 AM
Creating Spreadsheet that pull Names that have a pop. of 10+ Jonathan Excel Worksheet Functions 3 February 1st 08 09:46 PM
Push/Pull for Pop3 tshad Excel Discussion (Misc queries) 2 February 6th 07 10:04 PM
PULL function (Harlan Grove) - can it use Named Ranges? [email protected] Excel Worksheet Functions 3 July 28th 06 07:08 PM
Creating Pull Down Lists in Excel cells. John Rovenolt Excel Discussion (Misc queries) 2 July 20th 05 02:12 PM


All times are GMT +1. The time now is 11:49 AM.

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"