will this do it?
sub copyrows
rows(1).copy rows(2)
end sub
--
Don Guillett
SalesAid Software

"oercim" wrote in message
ups.com...
Hello, I want to write a macro on excel which makes the below
job:
I will have 2 variables let say a and b. Then , I want to copy
the rows between "row a" and "row b". That is all. I made such an
code,

dim a as integer
dim b as integer
Rows(XXXXXXXXX).Select
Selection.Copy


I cant fill the inside of the Rows( ) function. What is the
suitable way of writing this function? Is there a way? If not, how can
I do this job .Thanks alot.