Last cell selection .End(xlup) using VBA in Excel 2003 'lists' - requires two .Select to get correct cell?

I found that my use of . End(xlUp). Select prior to acting on the .

End(xlUp) cell was causing the problem. If I simply avoid the . End(xlUp).

Select prior to operating on the . End(xlUp) cell, the problem is less complex. It can be easily solved by preceding any .

End(xlUp) operation with . Range("A1").Select. See the code for explanation.

This doesn't really fix the problem with improper . End(xlUp) cell 'selection' - but I'm not interested in 'selecting' the cells, just operating on them. I must mention that I use .

Range("A1"). Select because A1 is outside of the 'list' that I'm manipulating via VBA.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions