Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a range stack
Hi.
I have a range (A1:J10) named "Person_01". Cell J1 contains a hyperlink called "Add_Person" with a label that says "Add a new person". When the user clicks the hyperlink, "Person_01" should be copied and inserted as "Person_02" right below "Person_01". The hyperlink at the bottom of "Person_01" should change to "Delete this person" and the hyperlink at the bottom of "Person_02" should still say "Add a new person". As new ranges are added, only the most current range will contain the "Add a new person" hyperlink, with all former ranges containing the "Delete this person" hyperlink. I've already written code to add/delete ranges, but I'm having a hard time tracking the range names as a "stack" so that I can name new/existing ranges properly upon addition/deletion of a person. Can somebody help me conceptualize this issue? I'm very new to VBA. Thanks. Michael *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a filtered range/named range | Excel Programming | |||
Creating a stack to push/pull ranges | Excel Programming | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Creating range name for a range selection | Excel Programming | |||
Creating an XL Range on the fly | Excel Programming |