Selecting next blank cell

[Yellowdude]

Ive got a table and i want excel to automatically go through all the table untill it finds a blank cell and then add an x to the empty cell. Is there a formula that can do this or a macro?

 

[Mark W.]

Use Edit | Go To... | Special... Blanks. Type "x" and press Control+Enter.

 

[Yellowdude]

No I want excel to automatically go to the cell without human intervention. Any other suggestions?

 

[Mark W.]

Write a VBA macro that upon opening the worksheet performs the Edit | Go To... Special Blanks described above.

 

[Yellowdude]

and how do i do that then im not that much of a programmer
whats the command line?

 

[Mark W.]

On 2002-03-05 12:15, Yellowdude wrote:
and how do i do that then im not that much of a programmer
whats the command line?

Unfortunately, I'm not much of a VBA programmer. Repost and specifically ask for VBA assistance.
This message was edited by Mark W. on 2002-03-05 12:19

 

[Yellowdude]

ahh is there anyone else out there?

 

[waggy30]

instead of writing a macro, how about simply recording a macro to do it

 

[Yellowdude]

tried it it wont record

 

[Mark W.]

Cells.Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "x"