Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel VBA troubleshooting

Comment:

hi i am trying to write a code that differentiates between a 0 and a blankcell in an excel sheet. the code : Public Sub test() If ActiveCell = "" Then MsgBox (" its blank ") If ActiveCell = 0 Then MsgBox (" its zero") End Sub gives me both the prompts if the activecell is blank. i tried giving an = 0 and NOT Blank, but it doesnt work. please advise. thanks raz

Name: dtech10
Date: September 16, 2002 at 14:06:11 Pacific

Reply:

Hi Razdamn You might be able to use expressions like: if IsBlank(ActiveCell) if IsNumber(ActiveCell) AND ActiveCell=0 Hope this helps

0

Name: A Certain TH
Date: September 17, 2002 at 08:11:35 Pacific

Reply:

Just append the activecell object with ".text": Sub tester() If ActiveCell.Text = "" Then MsgBox (" its blank ") If ActiveCell.Text = "0" Then MsgBox (" its zero") End Sub Cheers Tom

0

Reply:

thanks A-Certain-Th, it works.

0

XML and DTS Interaction (...

How to hijack INT 13h in ...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I'm trying to save an excel spreadsheet with the filename of K&N.csv but when I try and do this from within my macro, excel crashes when the workbook is closed. I can save the file and close the workb...

Summary: I am in need of assistance of an excel vba macro that i am creating. I am calculating the Canadian dollar by multipling cell "F2" * "G2". However, I am using a loop to do this and I am having troub...

Summary: I try to write a Macro or VBA subroutine, which removes in an Excel sheet all empty (except header) columns and rows, in order to make it more readable as a report. This is probably a trivial thing, b...