Return a letter in another cell is occupied

[luke.guthrie]

I need a code that will return a letter in a cell if another cell is occupied.

For example:

If A1:A7 are full I need B1:B7 to contain the letter U.

[abousetta]

Hi,

Do you mean if ALL cells in the range A1:A7 are full then ALL cells in the range B1:B7 should contain the letter "U" or for each cell in range A1:A7 that is full, put a "U" in the corresponding cell in column B?

[jraj1106]

Hi

Try this formula:

=IF(ISBLANK(A1:A7)=FALSE,"U","")

[luke.guthrie]

The formual would work however I can't have formulas in a cell

[jraj1106]

Do you want a macro?

[luke.guthrie]

Yes I need to add it into an existing macro

[abousetta]

Just put the formula in the cell and then remove the cell and leave the value using

Please Login or Register  to view this content.

[luke.guthrie]

I need to run a macro as I have 90 different files with different amounts of data

[jraj1106]

Check this out...

luke.xlsm

[luke.guthrie]

perfect thanks a lot!