Solved

Code - finding null

Posted on 2013-06-05
3
149 Views
Last Modified: 2013-06-06
How can I add to this for Sheet 4 where column AP is null??

Dim c As Integer, i As Long
 ClearSheet "CU_tmp", 2
 i = Sheet4.UsedRange.Rows.Count
 c = FindCol("Compare", 2, "Security CUSIP")
  If i > 65000 Then i = 2
  Sheet4.Range("A3").Offset(0, c).Resize(i, 1).Copy
  Sheet19.Range("A3").PasteSpecial xlPasteValues
  Application.CutCopyMode = False
0
Comment
Question by:leezac
3 Comments
 
LVL 13

Expert Comment

by:Shanan212
ID: 39222911
Do you want make sure that all rows in column AP are null? Could you explain please?
0
 

Author Comment

by:leezac
ID: 39222931
Are empty - no values in AP
0
 
LVL 22

Accepted Solution

by:
rspahitz earned 500 total points
ID: 39226082
Are you looking for something like this:

If Range("AP1").Value = Empty Or Range("AP1").Value = "" Then

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now