Finding the bottom right hand corner of a sheet in VBA

[popper]

I need to determine the location of the bottom and right most entry of an Excel worksheet in VBA. Is the a method or property somewhere in the Excel Object Library which will give me this.

I would appreciate any help here.

With thanks

 

[SkipVought]

Hi,

Turn on your macro recorder.

go to IV65537

Find *

Turn off your recorder

Observe your recorded code.

Change the direction of search.

Skip,

_[red][/red]

 

[PHV]

Have a look here: faq707-2112

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AnotherHiggins]

Or faq707-2115

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[popper]

Thank you for your valuable help.