View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pink Panther Pink Panther is offline
external usenet poster
 
Posts: 4
Default Find last nonblank cell in column

I have a small problem and don't know how to solve it...
Let's say I have range A1:A20 filled with some values and want to add a new
value in A21 but A19:A20 is hidden.
I tried range("A1:).end(xlDown).offset(1,0)="hallo", but the result of this
is that I fill range("A19") with "hallo" instead of range("A21")

How can I solve this little problem without unhiding those rows???

Thanks in advance,

Paul Bleijlevens