Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Cell fomatting

Cell fomatting

ResolvedVersion 2003

Thu 17 Jul 2008, 16:35 Delegate Steven said...

Steven has attended:
Excel VBA Intro Intermediate course

Cell fomatting

Is there a VBA method to clean a large amount of data, leaving e.g. #NA/NA cells empty and keeping proper numbers in a desired format?

Tue 19 Aug 2008, 14:44 Trainer Stephen said...

RE: cell fomatting

Hi Steven

Thanks for your question

The following code uses the IsError property of the range object to determine whether the cell contains an error. If it does, it changes the value to and empty string ""

If IsError(Range("A1").Value) = True Then

        

            Range("a1").Value = ""

            

End If

This code checks cell "a1", but you could place this in a loop and have the range determined as a variable so that it would cycle through a range of cells

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips

Cell fomatting

Cell fomatting

RE: cell fomatting

Excel articles

Excel tip:

Customize the toolbar in Excel 2010