I have a workbook into which I occastionally import new data sets, eac
in its own new worksheet. I need to delete the third row of each ne
worksheet (but not any not-new worksheet).
I'm trying to avoid using a loop to do this (as an exercise). So I'
wondering if I can define a new worksheets object called wsNewSheets a
a collection containing just the new worksheets and then do somethin
like
wsNewSheets.Rows(3).Delete
Would that work? I can't figure out how to 'populate' wsNewSheets.
Thanks,
Ma
--
MTT72
-----------------------------------------------------------------------
MTT727's Profile:
http://www.excelforum.com/member.php...fo&userid=2558
View this thread:
http://www.excelforum.com/showthread.php?threadid=39006