View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kossrs@yahoo.com is offline
external usenet poster
 
Posts: 3
Default 3 dimension array using Excel names

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