Name of Selected Cell

[Carrion]

I am using the Find command to locate the first date in 2004 in a list. Then I want to delete all rows above that. The problem is that I have no way of selecting all the rows above that without having the computer know what row I am currently in. Is there a way to have this value returned. thanks

 

[cLFlaVA]

Is this Excel?

The ActiveCell.Row property will give you the row that is currently selected.

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[SkipVought]

Hi,

The general approch to your problem would be along these lines...

...
set found = find([i]your find spec[/i])
if found is nothing then
  'nothing found process
...
else
  'found process -- delete rows above
  range(cells(1, 1), cells(found.row-1, 1)).entirerow.delete
end if

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244