VBA will not accept a worksheet name that referes to more than one worksheet.
To get multiple sheets you could do something like this

myaddress = Range("rw").Address
For Each sh In ThisWorkbook.Sheets
sh.Range(myaddress) = "123"
Next sh

" wrote:

Hello

I want to use name specification of 3-dim array (sheet, column, raw).

First define var "rw" using Menu-Insert-Name-Insert as
=Sheet1:Sheet3!$B$4:$D$5

Haw can i access any cell in "rw" range using VBA?

Construction -----Range("rw")----- cause the 1004 error - Method
'Range' of object 'Global' failed

Best regards,
Konstantin