Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: If Range("AZ" & intCounter).Text = "" Then
I have a very strange error in Excel 2003:
All cells in column AZ are empty. When I run this code: If Range("AZ" & intCounter).Text = "" Then it says that the cells contain the value TRUE. How can this be possible? Very grateful for help! // S |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: If Range("AZ" & intCounter).Text = "" Then
Hi,
I'm not sure I fully understand what you mean but if you apply the test If Range("AZ" & intCounter).Text = "" Then to the cells and they are empty then that will evaluate as TRUE, it doesn't mean the cell contains the value TRUE. For example try this small routine on your cells Sub nnn() For intcounter = 1 To 20 If Range("AZ" & intcounter).Text = "" Then MsgBox Range("AZ" & intcounter).Text = "" Else MsgBox Range("AZ" & intcounter).Text = "" End If Next End Sub Empty cell evalute as TRUE and populated cells evaluate as FALSE Mike " wrote: I have a very strange error in Excel 2003: All cells in column AZ are empty. When I run this code: If Range("AZ" & intCounter).Text = "" Then it says that the cells contain the value TRUE. How can this be possible? Very grateful for help! // S |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: If Range("AZ" & intCounter).Text = "" Then
I should add that if a cell in your range contains a formula such as
=if(A1="","","") which would always return a null string then your test would evaluate as TRUE for this cell despite it containing a formula. Mike " wrote: I have a very strange error in Excel 2003: All cells in column AZ are empty. When I run this code: If Range("AZ" & intCounter).Text = "" Then it says that the cells contain the value TRUE. How can this be possible? Very grateful for help! // S |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: If Range("AZ" & intCounter).Text = "" Then
You are applying a logical test...... if is = "" ....which will evaluate
TRUE, if the cell is empty, FALSE otherwise. -- Regards, Nigel wrote in message ... I have a very strange error in Excel 2003: All cells in column AZ are empty. When I run this code: If Range("AZ" & intCounter).Text = "" Then it says that the cells contain the value TRUE. How can this be possible? Very grateful for help! // S |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: If Range("AZ" & intCounter).Text = "" Then
After some more testing I've found that the problem is that
"Range("AZ" & intCounter).Text" returns nothing if the cell content only contains numbers. If I change to "Range("AZ" & intCounter).Value" it returns the content also if the content only is a number. Why doesn't it return the content with .Text? // S On 21 Jan, 10:52, "Nigel" wrote: You are applying a logical test...... if is = "" ....which will evaluate TRUE, *if the cell is empty, FALSE otherwise. -- Regards, Nigel wrote in message ... I have a very strange error in Excel 2003: All cells in column AZ are empty. When I run this code: If Range("AZ" & intCounter).Text = "" Then it says that the cells contain the value TRUE. How can this be possible? Very grateful for help! // S- Dölj citerad text - - Visa citerad text - |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: If Range("AZ" & intCounter).Text = "" Then
Hi,
I'm not sure how you tested and came up with the result you did but MsgBox Range("AZ" & intcounter).Text Will return a number if that's what's in the cell Mike " wrote: After some more testing I've found that the problem is that "Range("AZ" & intCounter).Text" returns nothing if the cell content only contains numbers. If I change to "Range("AZ" & intCounter).Value" it returns the content also if the content only is a number. Why doesn't it return the content with .Text? // S On 21 Jan, 10:52, "Nigel" wrote: You are applying a logical test...... if is = "" ....which will evaluate TRUE, if the cell is empty, FALSE otherwise. -- Regards, Nigel wrote in message ... I have a very strange error in Excel 2003: All cells in column AZ are empty. When I run this code: If Range("AZ" & intCounter).Text = "" Then it says that the cells contain the value TRUE. How can this be possible? Very grateful for help! // S- Dölj citerad text - - Visa citerad text - |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: If Range("AZ" & intCounter).Text = "" Then
And it's not just the value that's important--it's what you see in the cell--not
the formulabar. You could see ####'s returned (in .text) if the columnwidth isn't wide enough. You could see nothing (in .text) if the number format hides the value (custom format of ;;; for instance). But if you can see something in the cell, you should see something returned with ..text. wrote: After some more testing I've found that the problem is that "Range("AZ" & intCounter).Text" returns nothing if the cell content only contains numbers. If I change to "Range("AZ" & intCounter).Value" it returns the content also if the content only is a number. Why doesn't it return the content with .Text? // S On 21 Jan, 10:52, "Nigel" wrote: You are applying a logical test...... if is = "" ....which will evaluate TRUE, if the cell is empty, FALSE otherwise. -- Regards, Nigel wrote in message ... I have a very strange error in Excel 2003: All cells in column AZ are empty. When I run this code: If Range("AZ" & intCounter).Text = "" Then it says that the cells contain the value TRUE. How can this be possible? Very grateful for help! // S- Dölj citerad text - - Visa citerad text - -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Error Help - Method "Range" of object "_Worksheet" failed. | Excel Programming | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
"Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming |