Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro Check for Null field

Status
Not open for further replies.

buzzboychicago

Programmer
Sep 20, 2004
34


On entry of data I need to check A1 through H1 to find the first null field.

How would I do that programatically?
 


Hi,

I assume that you mean that if you enter data in row n, you want to find the first empty cell in An:Hn...

and then do WHAT?

Skip,

[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top