Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Selection row
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Selection row
Resolved · Low Priority · Version 2003
Reply
Selection row
Hi ThereI 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
For upcoming training course dates see: Pricing & availability
RE: Selection row
Hi SophieThank 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 SophieI 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.Thu 8 Apr 2010: Automatically marked as resolved.
|
 |
|
» Forum post: Templates |
How many templates can you reasonably use?
