Locate cell in Named Range
sorry, sent this to you email:
If it is contiguous (a single area range)
set rng = Range("ABCD")
rng.rows(rng.rows.count).offset(1,0).EntireRow.Ins ert
--
Regards,
Tom Ogilvy
"Steph" wrote in message
...
Anyone know how to programatically find the bottom left cell of a named
range? I need to find that cell, and insert an entire row beneath it.
Thanks!
|