SelectionChange and Dynamic Range. How to do it?

[JimmyWilliams]

Hi guys,

I want to have some code that activates when particular cells are selected within a dynamic range that Selectionchange can set.

The range in which I want this code to run will change over time. I want my selectionchange to be able to find the bottom of a table (A4) and then have this code only run within the table and within columns B and C.
Ie, not the whole of columns B and C, as I want to be able to have other things below this table that will not be affected).

See code below.

Thanks
Jimmy

Please Login or Register  to view this content.

[AlphaFrog]

Your example code doesn't do anything. So I'm a little confused what to are asking.

This displays a message if you select any cell in columns B or C of the table..

Please Login or Register  to view this content.

[JimmyWilliams]

Hey Alpha Frog,

Thanks for trying. You are correct the code wont do anything.. yet.

• code that will run only within Range(B1,c??). The number of rows within the table will change. However I don't want the code to run for the whole of columns B and C.
• code to run with selectionchange

The below code defines a dynamic range that depends on the table's size. However since it has a "Select" in it, the code causes an infinite loop with the selectionchange and crashes.

Please Login or Register  to view this content.

I guess I need an alternative way to dynamically define a range.

[AlphaFrog]

Hey Alpha Frog,

Thanks for trying. You are correct the code wont do anything.. yet.

• code that will run only within Range(B1,c??). The number of rows within the table will change. However I don't want the code to run for the whole of columns B and C.
• code to run with selectionchange

The below code defines a dynamic range that depends on the table's size. However since it has a "Select" in it, the code causes an infinite loop with the selectionchange and crashes.

The code I posted does exactly that (except for the infinite loop part).

[JimmyWilliams]

The code I posted does exactly that (except for the infinite loop part).

Hi AlphaFrog,

The code you pasted does work.. except it worked over the whole of Columns B and C, which is problematic in my case.

I need the code to work only until.. say B50 C50... or say B10000, C10000, however not over the whole of both columns.
The B50 C50/B10000 C10000 won't be determined until the SelectionChange starts running.

Thank you for your time, I hope I have made problem I have a bit more clearer.

[JimmyWilliams]

Maybe...
Maybe... you're right AlphaFrog..
I'll have another look at it tonight, and will write back.