View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny Bright Johnny Bright is offline
external usenet poster
 
Posts: 4
Default Selecting just my text

I need to find the bottom of my text. I have added some text and deleted it
and when I do this:

Range("A1").Select
ActiveCell.SpecialCells(xlLastCell).Select
ActiveCell.Offset(1, -10).Range("A1").Select

it goes to the bottom of wherever I have had data even if it has been
deleted as in, if I delete rows 10 to 20, the code above will still take me
to row 20 when I want to go to row 10 where my text is. How can I get around
this?

All help greatly appreciated.

J
--
www.brightfuture.ca/bright
My email address can be found on my site.