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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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 Nex

--
Brassma
-----------------------------------------------------------------------
Brassman's Profile: http://www.excelforum.com/member.php...fo&userid=1329
View this thread: http://www.excelforum.com/showthread.php?threadid=49606

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" wrote in message
ups.com...

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

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"
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"
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