Apparently empty (blank) cells aren't empty

		Microsoft Office Forums > Microsoft Excel > Excel
Apparently empty (blank) cells aren't empty

03-08-2012, 03:41 PM

daymaker

Windows XP Apparently empty (blank) cells aren't empty

Office 2000

Novice

Join Date: Feb 2012

Posts: 22

Issue resolved; I was able to select my range and run this code:

Sub test()
With Selection

.Value = .Value
End With
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Empty cells plotted as zero.	ColinC	Excel	2	01-23-2012 08:02 AM
Vba, Is there a better way to test empty cells?	Hwyn	Excel Programming	2	11-14-2011 11:44 AM
Empty rules	rene.kamphuis@ciz.nl	Mail Merge	21	04-15-2011 12:34 AM
Shared Calendar Empty	worksmart	Outlook	0	01-21-2011 06:32 AM
Populate an empty .PAB file	imported_contiw	Outlook	2	08-17-2006 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:57 AM.