ExcelBanter - Table array

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Table array (https://www.excelbanter.com/excel-discussion-misc-queries/55914-table-array.html)

I have a template that when I try to change some of the cells I get a
massage that I can not change them because of Table array, how can I
override it[

--
hapitaron
------------------------------------------------------------------------
hapitaron's Profile: http://www.excelforum.com/member.php...o&userid=12456
View this thread: http://www.excelforum.com/showthread...hreadid=485832

You need to select the whole of the array and change it en-bloc.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"hapitaron" wrote
in message ...

I have a template that when I try to change some of the cells I get a
massage that I can not change them because of Table array, how can I
override it[

--
hapitaron
------------------------------------------------------------------------
hapitaron's Profile:
http://www.excelforum.com/member.php...o&userid=12456
View this thread: http://www.excelforum.com/showthread...hreadid=485832

CTRL+A to select the whole of the array
--
topola