Click here to Skip to main content
14,836,641 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear,

I have a table in my excel 2007.In that table i have one column,in which i need to write text by using formula wherever the cell is blank.Kindly tell me the solution.

Thanks & Regards,
Viswanathan.M
Posted
Comments
Lakamraju Raghuram 13-Apr-12 1:15am
   
tag it with proper language

1 solution

Are you wanting to do this in code or directly in Excel?

1. In code, first record a macro doing what you want. Essentially you can loop through the Cell objects of the Range object you specify and check the Cell.Value and if it is blank set it to whatever text you want.

2. In Excel, we need more info but a simple IF function can be used.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900