Excel: .End(xlUp) doesnt work correctly 1

[waldemar]

Hm, still working on the problem...

later in the program I try to loop through a range that depends on the last entry-row of locPort.column (most of the times Column B).

The following llop returns no row at all though there is content in the cells (and it worked some time before. My assumption is that there is something wrong the End(xlUp) thing... but I have no clue... anybody???

(locPort is just a range containing a header cell)

For intRow = 1 To locPort.Cells(65000, locPort.Column).End(xlUp).row

 

[RobBroekhuis]

Change it to

For intRow = 1 To Cells(65000, locPort.Column).End(xlUp).row



Rob

 

[xlbo]

Answered in original thread with exactly the same response Rgds
~Geoff~

 

[waldemar]

Of course... the sheet instead of the reference cell... thanks!