I am trying to use the rows command. I know how to use it if the row is a
number. For example, I know that this would work: rows(1:1)

However I was to use a variable instead of a number. Here is what I have.
It isn't working. Thank you.


Rows("i:i").Delete Shift:=xlUp

Hi Adam,

Try:

Rows(i).Delete

---
Regards,
Norman



"Adam" wrote in message
...
I am trying to use the rows command. I know how to use it if the row is a
number. For example, I know that this would work: rows(1:1)

However I was to use a variable instead of a number. Here is what I have.
It isn't working. Thank you.


Rows("i:i").Delete Shift:=xlUp

hi,

this way, it should be OK.

Sub test()
I = 6
johndoe = I & ":" & I
Rows(johndoe).Interior.ColorIndex = 19

End Sub

see ya later

"Adam" a écrit dans le message de news:
...
I am trying to use the rows command. I know how to use it if the row is a
number. For example, I know that this would work: rows(1:1)

However I was to use a variable instead of a number. Here is what I have.
It isn't working. Thank you.


Rows("i:i").Delete Shift:=xlUp

Adam

Sub test()
Dim i As Long
i = InputBox("enter a number")
Rows(i).Delete Shift:=xlUp
MsgBox "row " & i & " was deleted"
End Sub





On Mon, 10 Jan 2005 14:23:02 -0800, "Adam"
wrote:

I am trying to use the rows command. I know how to use it if the row is a
number. For example, I know that this would work: rows(1:1)

However I was to use a variable instead of a number. Here is what I have.
It isn't working. Thank you.


Rows("i:i").Delete Shift:=xlUp