Thread: offset formatting question

i have a range of cells which is nxn where n>1. i want to place a header 2 rows above this range which is aligned on the left. this is what i tried:

Range("givenMatrix").Offset(-2, 0).Value = "YOUR MATRIX"

but this prints out an nxn matrix where all the values are "YOUR MATRIX". how can i select just the anchor cell of "givenMatrix" and move 2 rows above that to place the header?

thanks for any help.

Try

Range("givenMatrix").Offset(-2, 0)(1).Value = "YOUR MATRIX"

Originally Posted by shg

Try

Range("givenMatrix").Offset(-2, 0)(1).Value = "YOUR MATRIX"

brilliant. thanks a bunch.

Please mark this thread as solved, and start a new thread for your unrelated question.