Solved

Code - finding null

Posted on 2013-06-05
3
165 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel TimeLine stopped working? 36 60
Macro to change number to Month in Excel? 10 45
Frequency distribution of horizontal data? 5 29
List Box Entries Excel 2010 5 27
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

808 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