sure try
If len(application.trim(range(**A1)))1 Then
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- From: Seba
Sent: Thursday, November 10, 2011 9:48 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem
Hi,
I am testing this fairly simple code for some other purposes but I
always get the value 8 regardless of value in A1:
Sub testPogoja()
If IsEmpty(A1) Then
Exit Sub
Else
Range(B5).Value = 8
End If
End Sub
try this...
If range(A1).value = Then
Exit Sub
Else
Range(B5).Value = 8
End If
End Sub
regards,
Mrinal
On Thu, Nov 10, 2011 at 9:18 PM, Seba sebastjan.hri...@gmail.com wrote:
Hi,
I am testing this fairly simple code for some other purposes but I
always get the value 8 regardless of value
you forgot RANGE but to make sure try
If len(application.trim(range(A1)))1 Then
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Seba
Sent: Thursday, November 10, 2011 9:48 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ excel vba If IsEmpty(Range
If IsEmpty(Range) code problem
From: sebastjan.hri...@gmail.com
To: excel-macros@googlegroups.com
Hi,
I am testing this fairly simple code for some other purposes but I
always get the value 8 regardless of value in A1:
Sub
: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem
Hi,
I am testing this fairly simple code for some other purposes but I
always get the value 8 regardless of value in A1:
--**--**
Sub testPogoja()
If IsEmpty(A1) Then
Exit