Why does range evaluate to nothing following set statement

ok, i am enclosing two files similar to what i am using in this macro.


The code i am trying to understand is shown below:

Consider the top 6 rows. For some reason this code says that these top six rows are not the same in each file...................ie............

Please Login or Register  to view this content.

the above evaluates to "Nothing". I did figure out that if i remove the "extend across cols" that it will work but i am not sure why it does not work when i do " have these extended"


Can someone help me understand?

Please Login or Register  to view this content.

i have another question i cant figure out..........

rngSourceData.............what is this area/range?

my thought was that it was the first 6 cols and first 6 rows but if you run the code it goes beyone the 6th row.........so i dont know what this range is.

can somoene help?

i think i figured out what i needed to figure out..........still not 100% sure why this


Set rngFinder = wksTarget.Columns(1).Find(What:=wksSource.Cells(rngCell.Row, 1), lookat:=xlWhole)


evaluates to nothing......but i can live without knowing for now.

hi, welchs101, hope this will help to answer your both questions. Variable testsh is defined as Worksheet object, it's default value is Nothing and as Sheet("Sheet1") is absent it remains equal to Nothing. If it's nothing selection is made visible on the first sheet, run code "test".

thanks........that does help.