Testing for a Blank Cell

Sam40mUK · May 8th, 2002, 05:16 PM

Evening All,
This is just a quick question, with hopefully a quick answer.
I am looking to 'test' to see if a cell is blank within a macro.
I would be grateful if someone could please point me in the right direction.
Cheers
S

Qroozn · May 8th, 2002, 05:24 PM

try this

sub checkifempty
If Range("a1").Value = "" Then MsgBox "sorry 'ol chap. the cell is empty"
Exit Sub

Jay Petrulis · May 8th, 2002, 05:28 PM

Check the following:

http://www.mrexcel.com/board/viewtop...c=3186&forum=2

Sam40mUK · May 8th, 2002, 05:33 PM

Just a quick thank you to you both for responding so promptly.
I will be 'Excel'ling in the morning - testing for Blank Cells!
Cheers
S

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

May 8th, 2002, 05:16 PM	#1
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Evening All, This is just a quick question, with hopefully a quick answer. I am looking to 'test' to see if a cell is blank within a macro. I would be grateful if someone could please point me in the right direction. Cheers S

May 8th, 2002, 05:24 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	try this sub checkifempty If Range("a1").Value = "" Then MsgBox "sorry 'ol chap. the cell is empty" Exit Sub

May 8th, 2002, 05:28 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Check the following: http://www.mrexcel.com/board/viewtop...c=3186&forum=2

May 8th, 2002, 05:33 PM	#4
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Just a quick thank you to you both for responding so promptly. I will be 'Excel'ling in the morning - testing for Blank Cells! Cheers S