Selecting next blank cell

Yellowdude · Mar 5th, 2002, 01:08 PM

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. · Mar 5th, 2002, 01:09 PM

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

Yellowdude · Mar 5th, 2002, 01:10 PM

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

Mark W. · Mar 5th, 2002, 01:14 PM

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

Yellowdude · Mar 5th, 2002, 01:15 PM

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

Mark W. · Mar 5th, 2002, 01:18 PM

Quote:

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 · Mar 5th, 2002, 01:20 PM

ahh is there anyone else out there?

waggy30 · Mar 5th, 2002, 01:23 PM

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

Yellowdude · Mar 5th, 2002, 01:25 PM

tried it it wont record

Mark W. · Mar 5th, 2002, 01:33 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 01:08 PM	#1
Yellowdude New Member Join Date: Mar 2002 Posts: 20	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?

Mar 5th, 2002, 01:09 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Use Edit \| Go To... \| Special... Blanks. Type "x" and press Control+Enter.

Mar 5th, 2002, 01:10 PM	#3
Yellowdude New Member Join Date: Mar 2002 Posts: 20	No I want excel to automatically go to the cell without human intervention. Any other suggestions?

Mar 5th, 2002, 01:14 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Write a VBA macro that upon opening the worksheet performs the Edit \| Go To... Special Blanks described above.

Mar 5th, 2002, 01:15 PM	#5
Yellowdude New Member Join Date: Mar 2002 Posts: 20	and how do i do that then im not that much of a programmer whats the command line?

Mar 5th, 2002, 01:20 PM	#7
Yellowdude New Member Join Date: Mar 2002 Posts: 20	ahh is there anyone else out there?

Mar 5th, 2002, 01:23 PM	#8
waggy30 New Member Join Date: Mar 2002 Location: England Posts: 46	instead of writing a macro, how about simply recording a macro to do it

Mar 5th, 2002, 01:25 PM	#9
Yellowdude New Member Join Date: Mar 2002 Posts: 20	tried it it wont record

Mar 5th, 2002, 01:33 PM	#10
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Cells.Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.FormulaR1C1 = "x"