help: visual basic and excel

help: visual basic and excel

Post by HrlnG » Tue, 23 Feb 1999 04:00:00




>What is the equivalent of the excel functions INDIRECT and
>ADDRESS in visual basic? For example, how can I write
>INDIRECT(ADDRESS(X,Y))  (where X and Y are defined
>ranges in an excel spreadsheet) in visual basic? thanks

How about  ActiveSheet.Cells(x, y)  ?