Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Inefficient?

Is there a better way to write this??

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 1 And Target.Row < 1 And Target.Row < 2 And
Target.Row < 3 And Target.Row < 4 Then
Cells(Target.Row, 1).Value = Now
End If
End Sub

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
Inefficient Space Removal	Sauron	Excel Programming	5	January 2nd 04 11:03 AM
Inefficient Calculation of User Defined Functions in Excel 2000	Leandro Arias	Excel Programming	1	August 19th 03 05:02 PM
Loop worked but is it inefficient?	Bob Phillips[_5_]	Excel Programming	2	August 13th 03 12:10 AM
Loop worked but is it inefficient?	steve	Excel Programming	2	August 12th 03 09:16 PM
Inefficient VBA Code - Worksheets Property	Don Guillett[_4_]	Excel Programming	0	July 23rd 03 08:00 PM

All times are GMT +1. The time now is 11:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us