MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Worksheet_SelectionChange(ByVal Target As Excel.Range)


Posted by Carl B. on February 03, 2001 3:22 AM

Is there a way to set the range to specified columns?
So that only when a change in those columns happens it
then run thru the code?


Posted by Gregc on February 03, 2001 2:42 PM

if target.column = 2 then
code here
end if

for rows

if target.row = 4 then
code here
end if


Posted by Carl B on February 03, 2001 11:52 PM

Thank you Greg