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

Normally it would be

Rows(1:3).Delete Shift:=xlup


so you could do

j = 3
k = 20
Rows(j & ":" & k).Delete shift:=xlup

--
Regards,
Tom Ogilvy


"Walshy"

g.uk wrote in 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

Thanks loads this is great !!!

-----Original Message-----
Normally it would be

Rows(1:3).Delete Shift:=xlup


so you could do

j = 3
k = 20
Rows(j & ":" & k).Delete shift:=xlup

--
Regards,
Tom Ogilvy


"Walshy"

g.uk wrote in message news:156501c49b24$0df95af0
...
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


.

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
.

Rows(1:3).Delete Shift:=xlup

should have been

Rows("1:3").Delete Shift:=xlup

but the approach with variables is fine.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Normally it would be

Rows(1:3).Delete Shift:=xlup


so you could do

j = 3
k = 20
Rows(j & ":" & k).Delete shift:=xlup

--
Regards,
Tom Ogilvy


"Walshy"

g.uk wrote in 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

One of the more important aspects of Tom Ogilvy's solution was unstated
(though clear): *avoid* the ".Select" and "Selection". That syntax is
superfluous and inefficient.

Alan Beban

wrote:

Thanks loads this is great !!!


-----Original Message-----
Normally it would be

Rows(1:3).Delete Shift:=xlup


so you could do

j = 3
k = 20
Rows(j & ":" & k).Delete shift:=xlup

--
Regards,
Tom Ogilvy


"Walshy"

g.uk wrote in message news:156501c49b24$0df95af0

...

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


.

Just personal preference is to avoid using strings. Here is just one
additional idea.

Dim s, e 'start & end rows to delete
s = 5
e = 10
Rows(s).Resize(e - s + 1).Delete

Note that Excel assumes Shift:=xlUp when it is the entire row.

HTH
Dana DeLouis

"Walshy" wrote in 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