Change text of cell if cell is greater than nothink withen range

**D_Rennie** · 07-16-2009, 07:04 AM

Hello.

I would like to change the name of all cells withen xrange with a text value greater than nothink.

Please Login or Register  to view this content.

Thankyou

i know i can do it all at once like
range("E4:F60203").Value = ""
Though would like to know how its done one cell at a time

**Palmetto** · 07-16-2009, 07:52 AM

Do you mean if the cell is a blank you want the value to be "Test"?

Please Login or Register  to view this content.

If that's not correct, please be more clear in your explanation.

**romperstomper** · 07-16-2009, 08:24 AM

Top tip: under Tools-Opions in the VBE, make sure the 'Require variable declaration' option is checked on the Editor tab. It would have caught your misspelling of OneCell as onecel (with only one L). You still need to change .Text to .Value when writing to the cell.

**D_Rennie** · 07-16-2009, 10:32 AM

Cheers guys.
RomperStomper even with the 'Require variable declaration' option is checked it didnt seam to pick up on the spelling. Would be great if there was a spellcheck. Is there somthink else that i need to enable for this

As you can tell im not much of a pro-grammer

**shg** · 07-16-2009, 10:41 AM

Add Option Explicit to the very top of each module.

The VBE does this automatically when you tick the box and create a new module, but does not insert one retroactively in existing modules. The checkbox should more accurately be called "Add Option Explicit to new modules"