Selecting rows
hi.
what is the rest of your code that ids the start row and
end row??
-----Original Message-----
I am having trouble selecting rows in a macro and
deleting
them.
I know you normally would write:
Rows("a1:a3").select
Selection.Delete Shift:=xlUp
problem I am having is the rows are vaiables..
I have wrote code to pick up a set a start & end row as
dim startrow and dim endrow
How do I the select that range ???
I tried Rows(startrow:endrow).select but no joy ???
Help me please...
Thanks
.
|