How to prevent a cell to disappear

		Microsoft Office Forums > Microsoft Word > Word VBA
How to prevent a cell to disappear

08-28-2019, 06:01 PM

eduzs

Windows 10 How to prevent a cell to disappear

Office 2010 32bit

Expert

Join Date: May 2017

Posts: 266

Try that (backup before doing any modification):
after Set rng statement:

Code:

rng.Cells.WrapText = True

Modify:

Code:

.PasteSpecial DataType:=1

To:

Code:

.Paste

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
Prevent cell from expanding vertically.	snowboarder2	Word Tables	1	08-24-2016 02:52 PM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Data Validation - Prevent blank cell based on a condition	dawd	Excel	2	08-12-2015 05:44 AM
Word tables: prevent word from highlighting whole cell when I highlight text	skylark53	Word	2	08-04-2015 08:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:51 PM.