Basic Question about varaibles

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" <Adam@discussions.microsoft.com> wrote in message
news:C2FCEBE3-E606-4741-816A-DA6C4ABE78BE@microsoft.com...
>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" <Adam@discussions.microsoft.com> a écrit dans le message de news:
C2FCEBE3-E606-4741-816A-DA6C4ABE78BE@microsoft.com...
> 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" <Adam@discussions.microsoft.com>
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