Selection row

Resolved · Low Priority · Version 2003

Fri 12 Feb 2010, 16:30 Delegate Sophie said...

Sophie has attended:
Excel VBA Advanced course

Selection row

Hi There
I am not sure how this all work so I will give it a go and please do tell if this is not a suitable question for the forum.

I have a complicated macro that I have simplified below.
Basically the macro work and select the line that I want but automatically deselect the one before.

What could I use so that in the end I have for example 5 lignes selected?

Every line that contains the word test are still selected and not the last one!

Thank you

Dim rngCell As Range

For Each rngCell In Range("C5:C50")

If rngCell = "Test" Then

rngCell.Activate
Range(Cells(ActiveCell.Row, "D"), Cells(ActiveCell.Row, "DD")).Select

Else

End If

Next rngCell
End Sub

Wed 17 Feb 2010, 10:51 Trainer Andrew said...

RE: Selection row

Hi Sophie

Thank you for your message. We will ask one of our VBA trainers to take a look at your question and get back to you. If the scope of the question is outside those normally covered by the forum we will let you know and suggest alternative means of resolving your question.

Kind regards,
Andrew

Mon 8 Mar 2010, 14:40 Trainer Andrew said...

RE: Selection row

Hi Sophie

I have checked and it will take some development time in order to produce a solution for you. This moves it out of the scope of the forum and would be handled as part of our consultancy services which is billable work. Let me know if you would like me to arrange one of our team to give you a call and discuss how we can take this forward.

Kind regards,
Andrew

Thu 1 Apr 2010, 14:37 Trainer Andrew said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 8 Apr 2010: Automatically marked as resolved.

Training courses