I have an area which I do not want to change but would like to have another area where I can change rows and column sizes without effecting the other area if you get my meaning?
What area? Please definite precisely the area by name or by reference.
Or please upload a sample file here, and colorize the area that yout want to change.
You can resize the width of the area B3:C4 together the size of the cells B1, C1, B2, C2, B5, C5, B6, C6 (and more)... in these columns or
you can resize the height of the area B3:C4 together the size of the cells A3, A4, D3, D4, E3, E4 (and more)... in these rows.