BillyH
02-27-2012, 04:39 AM
Hi,
Please can someone assist.
Found the attached in the forum under which works great for a defined range If Not Intersect(Target, Range("A1")) Is Nothing Then (Code Under Sheet1)
I would like to change this to look at the last row in a column e.g
If Not Intersect(Target, Range("A1:F" and Last_Row)) Is Nothing Then
but where do I place the :dunno
Last_Row = Sheets("Sheet1").UsedRange.Rows.Count
to define the last row
Thanks BillyH
Please can someone assist.
Found the attached in the forum under which works great for a defined range If Not Intersect(Target, Range("A1")) Is Nothing Then (Code Under Sheet1)
I would like to change this to look at the last row in a column e.g
If Not Intersect(Target, Range("A1:F" and Last_Row)) Is Nothing Then
but where do I place the :dunno
Last_Row = Sheets("Sheet1").UsedRange.Rows.Count
to define the last row
Thanks BillyH