Thread
:
Insert A Row Macro
View Single Post
#
2
Trevor Shuttleworth
Posts: n/a
Mark
something like:
Range("PriorPTI").Offset(-1, 0).Resize(1).EntireRow.Insert
will insert 1 row in front of the range called PriorPTI
Regards
Trevor
"Mark Williams" <Mark
wrote in message
...
Hi All,
I am trying to write a macro that will insert a row above a blank row in a
range I've named "PriorPTI". The blank row is the last row in a range that
contains 12 rows. The range will grow as I insert more rows. I am not a
programmer so any help will be greatly appreciated as I've spent two work
days trying to figure this out (Yes: it is rocket science :-)).
Regards,
Mark
Reply With Quote