Hi,

Is there line/s of code like

if activecell = "" then go here
if not continue code

Thanks

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

if Activecell.Value = "" then
do something
else
do something else
endif

HTH
--
AP

"FIRSTROUNDKO via OfficeKB.com" <u15639@uwe a écrit dans le message de
news:5da39bf08fb67@uwe...
Hi,

Is there line/s of code like

if activecell = "" then go here
if not continue code

Thanks

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

If ActiveCell.Value = "" Then
[code if true]
ElseIf [another condition if you like] Then
[code if true]
Else
[code if false]
End If


"FIRSTROUNDKO via OfficeKB.com" wrote:

Hi,

Is there line/s of code like

if activecell = "" then go here
if not continue code

Thanks

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200603/1

AP,

Thanks just perfect

Darren

Ardus Petus wrote:
if Activecell.Value = "" then
do something
else
do something else
endif

HTH
--
AP

Hi,

[quoted text clipped - 6 lines]

Darren

--
Message posted via http://www.officekb.com