PDA

View Full Version : Search a range of columns for values?



jayzeus
07-13-2008, 03:47 PM
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?

Bob Phillips
07-13-2008, 05:03 PM
columns("A:Z").find("").select
Activecell.Value="something"