Posted to microsoft.public.excel.programming

Mark

external usenet poster

Posts: 989

Workshet onchange

I am using EXCEL 97.

I have used the following:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

But I am getting a debug prompt regularly.

I want monitor changes to only a range of B9:AC13.

Is there a way to set it so that it only monitors this part and if so can
anyone assist me please?

--
Mark

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic extend row in workshet.	Rao Ratan Singh	New Users to Excel	0	February 4th 06 06:05 PM
Automatic extend row in workshet.	Gary''s Student	New Users to Excel	0	February 4th 06 02:37 PM
OnChange Event for a Cell	Michael Kintner	Excel Programming	3	January 5th 04 08:29 PM
OnChange - argh! How do I get this to work please?	mightyginger	Excel Programming	1	December 9th 03 12:35 PM
Inserting time stamp onchange of any cell	Mitchell Carey	Excel Programming	1	August 8th 03 08:09 AM

All times are GMT +1. The time now is 03:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us