Replace all null values with "null"

[UCAtech]

Hey everyone, I'm a PHP developer so this Microsoft stuff is throwing me for a loop!.

I have the need to populate all null values within the scope of the columns on all worksheets with "null".

Is this possible with VBA?

Dummy Data (What I have):
A B C D
1 Column1 | Column 2 | Column3 |
2 55342 | | 34223 |
3 343223 | 342343 | |
4 | 3243555 | 345555 |
5
6

Desired Data:
A B C D
1 Column1 | Column 2 | Column3 |
2 55342 | "null" | 23422 |
3 343223 | 342343 | "null" |
4 "null" | 3243555 | 345555 |
5
6

The replacing of null values should end at C and 5 (both of which will be changing daily.

Ben Boyd
Technical Writer/Programer/Student
opspeedydude@hotmail.com
Linuxbox Server Stats: 700mhz, 1024 MB RAM, 120 GB HD, Fedora 3
Laptop Stats: 2.0 Ghz, 1024MB RAM, 40GB HD, Windows XP Professional
Desktop Stats: 2.6 Ghz, 2048MB RAM, 3 x 120 GB HD, ATI Radeon x800 Pro, Windows XP Media Center Edition

 

[Golom]

Probably better to ask in forum707 (VBA For Applications). This is the Access Modules forum.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]