Geek Stuff |
![]() ![]() |
Excel / VBA - Defining Address Location |
![]() ![]() ![]() |
Christopher
Moderator
Member Rara Avis
since 1999-08-02
Posts 8296Purgatorial Incarceration ![]() |
I'm working on a program in excel which requires a specific row in which to start looking for something to do stuff with/to. The problem is that the row changes depending on several variables. At the moment I have an extensive "library" of where it will be if this variable and this variable are such-and-such and if this variable and this varaiable are this-and-that... but I need to add more variables. I can name a cell where it starts and locate it by the name. That's not a problem. The problem is that once it finds this row, it needs to be able to sequentially run down the following rows... which doesn't work unless I can define inside the program exactly what row it starts in. Getting the name will only help if I can have the actual row number returned somehow. I've looked through the book, looked on the net and can't seem to find a way. Am I just stuck or is there a way to do this? Thanks Chris egowhores.com - really love yourself. |
||
© Copyright 2005 C.G. Ward - All Rights Reserved | |||
SEA![]() ![]()
Moderator
Member Seraphic
since 2000-01-18
Posts 22676with you |
I have no idea what you are talking about...but you sure do look good saying it Kissy... ![]() |
||
Ron
Administrator
Member Rara Avis
since 1999-05-19
Posts 8669Michigan, US |
code: That should put you on the right path, Chris ... ![]() |
||
Christopher
Moderator
Member Rara Avis
since 1999-08-02
Posts 8296Purgatorial Incarceration |
Thanks, Ron. This looks close to what I want. I'll give it a shot! egowhores.com - really love yourself. |
||
serenity blaze Member Empyrean
since 2000-02-02
Posts 27738 |
What? No "mathy stuff"? ![]() *pout* |
||
Christopher
Moderator
Member Rara Avis
since 1999-08-02
Posts 8296Purgatorial Incarceration |
If you insist, Karen... code:If you'll notice, the above formula has been seen in a similar form before, in this very same forum.Do ![]() |
||
Christopher
Moderator
Member Rara Avis
since 1999-08-02
Posts 8296Purgatorial Incarceration |
And Ron, that works perfectly. All I had to change was "RefersToRange.Address" to "RefersToRange.Row" - the VITAL part being the knowledge of "RefersToRange" in the first place. ![]() Again, thank you. This will help me clean up my program considerably! |
||
serenity blaze Member Empyrean
since 2000-02-02
Posts 27738 |
*curtsy* ![]() |
||
![]() ![]() |
⇧ top of page ⇧ |
![]() ![]() ![]() |
All times are ET (US). All dates are in Year-Month-Day format. |