View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default row (i:j).select

Rows("i"&":"&"j").Select


HTH
--
AP

"ina" a écrit dans le message de
ups.com...
Hello,

I have this piece of code: I would like to input in row.select the
range of the row.

cell = Range("A" + CStr(i)).Value
cell2 = Range("A" + CStr(j)).Value

If (cell) = (cell2) And (cell) < " " Then


Rows("""i + ":" + j""").Select
Selection.Delete Shift:=xlUp

Else

i = i + 1
j = j + 1


End If

I have a problem in rows statement.

Thank you

Ina