98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VbNullString - not working??
VbNullString - not working??
Resolved · Medium Priority · Version 2003
Mon 22 Sep 2008, 16:02Delegate Richard said...
Richard has attended:
Excel VBA Intro Intermediate course
VbNullString - not working??
Hi there,
I have tried using the vba function vbNullString as below,
If Range(ActiveCell) = vbNullString Then
ActiveCell.EntireRow.delete
it scans through the data, but does not identify the cells as having no data within them and therefore it does not delete the row, I have also tried:
If ActiveCell.Value. = " " Then
ActiveCell.EntireRow.delete
Again, this doesnt seem to identify empty cells and doesnt delete the row.
The data originally came from a text file - is this linked to the problem?
Any advice or a better way to do it please?
Thanks for your help.
Fri 26 Sep 2008, 11:32Trainer Laura said...
RE: vbNullString - not working??
Hi Richard
Welcome to the joys of finding empty cells, it can be tricky.
The cells could contain spaces which would fail on the above tests.
I would try
If Trim(Activecell.Value)=vbNullString Then Activecell.EntireRow.DeleteRemember to be careful that you only need to move down a row when you do not delete a row.
Let me know how you get on.
Laura GB
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quick Zooming in Excel with rollerball mousesTo zoom in and out of your page hold down the control key and roll the wheel up and down. This will zoom up and down 15% at a time. |
