Reading and writing a 40x40 matrix using VBA code

Hi again. Having written my first couple of basic VBA macros I'm back with a slightly more complex request. I'm still a novice so please treat me as such!

I have a 40 by 40 matrix (so 1600 cells) which I want to read with vba code. I then want to write that same matrix back into my excel spreadsheet. Matrix contains numeric values.

I'm hoping that there is a quick and easy way to do this and would really appreciate some code for reading the Matrix and putting it back into another location in the spreadsheet. I think I can work out the other code I need for my purpose if I can just get some help on how to read and write this Matrix.

My goal is to perform multiple multiplication iterations (MMULT) on a Markov State to State Transition Matrix to reach a Steady State Matrix.

As previously, I will be very grateful for any guidance.

OK sounds great. Sorry for a very basic follow up question. How do I specify a range... so if I have a 20 by 20 matrix from A1 to U20, how would I do this?

Sorry if this is basic. I have only just worked out how to read and write a single cell.

and then

Please Login or Register  to view this content.

if I am writing back to same place? Any other code required or would these two lines be standalone? Sounds too easy!!

Much appreciated!

Great many thanks! Extremely helpful. Worked a treat and now I'm starting to get it!