Using VBA.

Formulas cannot hide rows or columns.

They can only return results to the cell.


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 11:45:05 -0700, Ray wrote:

Hi, I am a new user and would appreciate some help with what is probably a
simple problem. Using the formula below I am copying data from one worksheet
to another based on if data exists in one of 3 cells. If there is no data in
either of these cells I would prefer to hide the row instead. How can I do
this?

=IF(JobList!$K2<"",JobList!A2,IF(JobList!$L2<"" ,JobList!A2,IF(JobList!$M2<"",JobList!A2,"")))