Error Handling

[SBF12345]

I would like to use an error handling statement to define string variable if an error occurs. The error has the potential to occur if the value of RngEnd is near enough to the top of the sheet to return a value that would be outside of the sheet. How can I do this so that the error handling method is only used during this line of code?

RngFutureR = RngEnd.Offset(-25, 0).Address

I would like to write something like

On Error RngFutureR = string value

 

[Kamolga]

What about

On Error GoTo errHandler
[COLOR=#333333]RngFutureR = RngEnd.Offset(-25, 0).Address

[/COLOR]errHandler:
[COLOR=#333333]RngFutureR = string value[/COLOR]

 

[Fluff]

Rather than an error handler, how about

If rngEnd.Row < 26 Then
   RngFutureR=???
Else
   RngFutureR = rngEnd.Offset(-25, 0).Address
End If

 

[SBF12345]

Thanks, exactly what I was looking for!

 

[Fluff]

Glad we could help & thanks for the feedback