ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   display array in a range (https://www.excelbanter.com/excel-programming/359681-display-array-range.html)

ina

display array in a range
 
Hello all,

I would like to ask you one thing concerning array displaying. I have
one function that contains a display


mafuction(client code as string) as variant


from a sub I call this function:
Code = mafunction(ClientCode)

But ma problem is how to display the array everywhere I click in a cell
in my sheet. My array has 6 column; so from every cell I select I need
to calculate 5 column far from this cell in order to calculate my
range.

Ina



All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com