two very simple questions

1. How to get the row number if I'm in Target
2. How to tell Vb if is error then goto next step in the macro
TIA

1) Target.Row
2) On Error Resume Next

Brassman wrote:
> 1) Target.Row
> 2) On Error Resume Next
>
>
> --
> Brassman
> ------------------------------------------------------------------------
> Brassman's Profile: http://www.excelforum.com/member.php...o&userid=13290
> View this thread: http://www.excelforum.com/showthread...hreadid=496069

I was trying to achieve the result in Item 2 above with the Solver
module in VBA. However, I am not able to stop the Solver from
displaying the Error handling Dialog box "Show trial solution" . I
tried Placing the command "On Error Resume Next" at different places.
Any suggestions?
thanks in advance
googlesury

Read through this and see if it answers your question:

http://support.microsoft.com/default...b;en-us;843304
How to create Visual Basic macros by using Excel Solver in Excel 97

--
Regards,
Tom Ogilvy


"googlesury" <[email protected]> wrote in message
news:[email protected]...
>
> Brassman wrote:
> > 1) Target.Row
> > 2) On Error Resume Next
> >
> >
> > --
> > Brassman
> > ------------------------------------------------------------------------
> > Brassman's Profile:
http://www.excelforum.com/member.php...o&userid=13290
> > View this thread:
http://www.excelforum.com/showthread...hreadid=496069
>
> I was trying to achieve the result in Item 2 above with the Solver
> module in VBA. However, I am not able to stop the Solver from
> displaying the Error handling Dialog box "Show trial solution" . I
> tried Placing the command "On Error Resume Next" at different places.
> Any suggestions?
> thanks in advance
> googlesury
>

filo666,

1) Target.Row will return the first row of target
2)
On Error Resume Next
'code to skip
On Error Goto 0

hth,

Doug


"filo666" <[email protected]> wrote in message
news:[email protected]...
> 1. How to get the row number if I'm in Target
> 2. How to tell Vb if is error then goto next step in the macro
> TIA

Hi Filo666,

> 1. How to get the row number if I'm in Target

MsgBox Target.Row

> 2. How to tell Vb if is error then goto next step in the macro

On Error Resume Next

'Youe contentious code line

On Error GoTo 0 ' Restore default error handling

---
Regards,
Norman


"filo666" <[email protected]> wrote in message
news:[email protected]...
> 1. How to get the row number if I'm in Target
> 2. How to tell Vb if is error then goto next step in the macro
> TIA

Hi Flo,

Dim i As Integer
i = Target.Row

On Error Resume Next

HTH
Regards,
Howard


"filo666" <[email protected]> wrote in message
news:[email protected]...
> 1. How to get the row number if I'm in Target
> 2. How to tell Vb if is error then goto next step in the macro
> TIA

I know how to accomplish number 1: Range(target.address).Row
please just answer number 2.
"filo666" wrote:

> 1. How to get the row number if I'm in Target
> 2. How to tell Vb if is error then goto next step in the macro and also if is error goto Next (of a loop)
> TIA

On Mon, 26 Dec 2005 13:18:01 -0800, "filo666"
<[email protected]> wrote:


I will point you to the relevant topics in HELP, so you can also learn how to
find answers for other questions:

>1. How to get the row number if I'm in Target

Check HELP for the Row property.

>2. How to tell Vb if is error then goto next step in the macro
>TIA

Look at HELP for the RESUME statement.
--ron

thanks you all

"Ron Rosenfeld" wrote:

> On Mon, 26 Dec 2005 13:18:01 -0800, "filo666"
> <[email protected]> wrote:
>
>
> I will point you to the relevant topics in HELP, so you can also learn how to
> find answers for other questions:
>
> >1. How to get the row number if I'm in Target
>
> Check HELP for the Row property.
>
> >2. How to tell Vb if is error then goto next step in the macro
> >TIA
>
> Look at HELP for the RESUME statement.
> --ron
>