PDA

View Full Version : Solved: Comparing 2 Sheets in a Workbook minor bug



itipu
02-27-2007, 01:07 PM
Ladies & Gents,

Some minor bug in my script except can't quite figure out what it is...

I am tring to compare Column A in sheet1 with column A in sheet2 and whatever is not found in sheet2's Column A should be outputted to sheet3 column A at the moment it starts ok, but does not do next for some reason :(

Your help as always is much appreciated!!!!!!

Thanks a lot

mdmackillop
02-27-2007, 01:56 PM
Hi Itipu,
Minor bug as you said. You're writing all your data to the same cell A1.

Try
If rngFind Is Nothing Then
rngCell.EntireRow.Copy sh.Cells(Rows.Count, 1).End(xlUp).Offset(1)
End If

itipu
02-27-2007, 09:44 PM
Thanks