• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

VBA Excel Comparison

Hi Experts,

Wondering if I could get some assistance.  I have VBA that is comparing SourceData tab to Cost Tracker Budget Info tab to find the new project numbers on the SourceData tab and copy to the bottom of the Cost Tracker tab.  My problem is that the VBA is copying all of the project numbers over the VBA is at the bottom of the SourceData module.  When I tried to isolate the VBA and placed into Module1 the VBA errored on
Set findit = ws.Range("A4:a").Find(what:=ce.Value, lookat:=xlWhole)

Open in new window

.  And I am not sure why.

Any assistance would be appreciated.
EE-Test-2014.09.09.xlsm
0
jmac001
Asked:
jmac001
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
The specified range is incomplete.  Try this:
Set findit = ws.Range("A4:A" & Cells(Rows.Count, 1).End(xlUp).Row).Find(what:=ce.Value, lookat:=xlWhole)

Open in new window


Regards,
-Glenn
0
 
jmac001Author Commented:
Thank you works perfectly.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Tackle projects and never again get stuck behind a technical roadblock.
Join Now