ExcelBanter - Worksheet_Change and range test

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Worksheet_Change and range test (https://www.excelbanter.com/excel-programming/326601-worksheet_change-range-test.html)

Willow[_5_]

Worksheet_Change and range test

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

Mangesh Yadav via OfficeKB.com

Worksheet_Change and range test

Try
if Target.Cells.Count 1

Mangesh

--
Message posted via http://www.officekb.com

All times are GMT +1. The time now is 01:13 AM.