What range is a cell in?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Concerning Excel VBA: Does anyone know of a way that I can find out what range a particular cell (ActiveCell) is in? Here's the situation: I have several named ranges in a worksheet. When a cell changes, if it is in a particular range, then some code needs to be executed, and, if it's in another range, other code needs to be executed

Thanks!
 
I use "Change-Event" processing to detect when a cell value
has been altered. I'm sorry, but to explain it will take
more room than I have available here. See if you can find
an explanation of Event processing somewhere like in John
Walkenbach's book on VBA programming.
-----Original Message-----
Concerning Excel VBA: Does anyone know of a way that I can
Click to expand...
find out what range a particular cell (ActiveCell) is in?
Here's the situation: I have several named ranges in a
worksheet. When a cell changes, if it is in a particular
range, then some code needs to be executed, and, if it's in
another range, other code needs to be executed.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
What range is a cell in? 4
Excel VBA - Problem with Closing Print Preview 0
Populating a range of empty cells with usernames 4
Excel VBA 1
Array with many cells from a row but not in order or together 11
Code to Concat a row in loop 2
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 2

Back
Top