UCAtech
Technical User
- Dec 5, 2003
- 29
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
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