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