VBA format for a variable cell selection

[ramaboy]

Hi,
..
I would like to know how the following Excel 4 macro command can be
converted to VBA
=SELECT("R"&z+7&"C6")

I have no problem defining the variable "z" value, however I have been
unable to convert the above format into VBA.

Many thanks in anticipation.

 

[Bob Phillips]

Cells(z+7,6).Select

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ramaboy]

Cells(z+7,6).Select

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)








- Show quoted text -

Thanks a million Bob.
I must say that together with my 9 year break in writing macros and
with the evolution of VBA I have been somewhat
left behind. Thanks again for your help.