Basic Question about varaibles

[Guest]

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

 

[Norman Jones]

Hi Adam,

Try:

Rows(i).Delete

 

[anonymousA]

hi,

this way, it should be OK.

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

End Sub

see ya later

 

[Gord Dibben]

Adam

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