I was wondering what command would I use to scan a range of columns (for example A-Z) looking for a certain value (like a blank for example) and assigning a string value to it, and putting a highlight in it?
I was wondering what command would I use to scan a range of columns (for example A-Z) looking for a certain value (like a blank for example) and assigning a string value to it, and putting a highlight in it?
[vba]
columns("A:Z").find("").select
Activecell.Value="something"
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber