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.

Cells(z+7,6).Select

--
---
HTH

Bob

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



wrote in message
oups.com...
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.

On Aug 15, 8:16 pm, "Bob Phillips" wrote:
Cells(z+7,6).Select

--
---
HTH

Bob

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

wrote in message

oups.com...



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.- Hide quoted text -

- 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.