View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Euh Euh is offline
external usenet poster
 
Posts: 2
Default Manipulating matrices of unknwon (a priori) size

Hello,

In one of my worksheet, a user has to input columns of data.
The categories (columns) are fixed, but the number of data (lines) may
vary,

I eventually need to invert and multiply matrices, but the size of
these matrices will depend on
the number of data (lines),

I know how to do it manually by selecting the cells.
I know I could probably do it all using VBA

But is there a quick way to implement it automatically purely in a
worksheet ?