Range Syntax

[Mantle51]

Hello,

I have the following code which works but I don't know why it doesn't cause an error.

Dim rng As Range, k as Integer
k = InputBox("Enter Start Row")

Set rng = Range("B" & k, [B2].End(xlDown)) >>This works, but when I try to substitute the second [B2] with ["B" & k], it will not run.

Hypothetically, if k=10, then how can the logic be correct?

 

[firefytr]

I generally stay away from shorthand notation (that is keeping the range reference in [] square brackets) and you can't mix/match numbers with that type of notation either. Instead, use ...

Dim rng As Range, k as Integer
k = InputBox("Enter Start Row")

Set rng = Range("B" & k, Range("B" & k).End(xlDown))

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci