How do I use a for loop with excel

I am making a for loop that draws in excel and I cannot get the right syntax to change the row given the iteration constant "z". My for loop works when I have for example: 'B5:D5', but when i want to incorporate the iteration constant it does not work. Help please

height = 5

for z = 1:18

    if height == z

    s= xlsread('myexcelfile','sheet','Bz:Bz')

....the rest of the loop works fine,

Answer 1

[Andrei Bobrov]

height = 5
for z = 1:18
    if height == z
        s= xlsread('myexcelfile','sheet',sprintf('B%d',z));
    end
    ...
end

[carl chew]

sorry i meant 'Bz:Dz'

how would i write that?

[Andrei Bobrov]

height = 5
for z = 1:18
    if height == z
        s= xlsread('myexcelfile','sheet',sprintf('B%d:D%d',z,z));
    end
    ...
end