Dear,
I am a new poster. I found lots of information here about many ways to program and I am working as of today on an import file.
What it means is that there is a file in which information is held and it needs to go in a specific format in another file to be imported in a CRM.
What I have as of today is this:
Now I'm stuck because I need to know how I can select a number of rows between 2 weeks.
it can be a variable amount of cells to be selected of course
[TABLE="width: 500"]
<tbody>[TR]
[TD]WEEK 19
[/TD]
[/TR]
[TR]
[TD]value to be selected
[/TD]
[/TR]
[TR]
[TD]value to be selected
[/TD]
[/TR]
[TR]
[TD]value to be selected
[/TD]
[/TR]
[TR]
[TD]WEEK 20
[/TD]
[/TR]
</tbody>[/TABLE]
I am a new poster. I found lots of information here about many ways to program and I am working as of today on an import file.
What it means is that there is a file in which information is held and it needs to go in a specific format in another file to be imported in a CRM.
What I have as of today is this:
Code:
Dim constFixWeek As String
Dim rngRange As Range
Dim strPlanning As String
Dim wrkRollout As Workbook
Set wrkRollout = Excel.ActiveWorkbook
Dim shtplanning As Worksheet
strPlanning = "Planning Materiel"
Set shtplanning = wrkRollout.Worksheets(strPlanning)
constFixWeek = "WEEK "
strSelectCell = constFixWeek & intWeek
Set rngRange = shtplanning.Cells.Find(What:=strSelectCell, _
LookIn:=xlValues, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
If Not rngRange Is Nothing Then
rngRange.Select
Else
MsgBox "No match found."
End IfNow I'm stuck because I need to know how I can select a number of rows between 2 weeks.
it can be a variable amount of cells to be selected of course
[TABLE="width: 500"]
<tbody>[TR]
[TD]WEEK 19
[/TD]
[/TR]
[TR]
[TD]value to be selected
[/TD]
[/TR]
[TR]
[TD]value to be selected
[/TD]
[/TR]
[TR]
[TD]value to be selected
[/TD]
[/TR]
[TR]
[TD]WEEK 20
[/TD]
[/TR]
</tbody>[/TABLE]
