Worksheet_Change and range test

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

Guest

Hi,

I'd like to know how to test within an event macro that the active selection
(user made) is only one cell and not a mulitple cell range to use the
property .value on the target. How to test this ?
Thanks in advance.
Willow
 
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

Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
VBA set thick borders around non empty cells in range 0
Clear a "moving" range offset from Target 31
Trying to run excel vba code when cell value changes from empty to entered value. 1
Testing for a Cell within a range 4
Worksheet_Change() and Range question 3
Setting Default Values in Range When User Enters Blank Value 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Back
Top