VBA Beginner
New Member
- Joined
- Mar 15, 2011
- Messages
- 1
Hi,
I am trying to write some code in VBA and I wondered if you could help me a little?
I have to Select Rows in Column A that are between T S and V E (I've coloured the selection)
V B
V [CB] Variable for Concept Break
T S
R Product\Quaker Oat So Simple Original *(a)
Y $QHIDCELL/1
R Quaker Oat So Simple Fruity Flavours *(b)
Y $QHIDCELL/2
R Quaker Oat So Simple Classic Flavours *(c)
Y $QHIDCELL/3
R Quaker Oat So Simple Nut Clusters *(d)
Y $QHIDCELL/4
R Quaker Oat So Simple Indulgence *(e)
Y $QHIDCELL/5
R Quaker Oats *(f)
Y $QHIDCELL/6
R Quaker Oats Sustain *(g)
Y $QHIDCELL/7
R Quaker 'Grade A' Oats *(h)
Y $QHIDCELL/8
R Ready Brek *(i)
Y $QHIDCELL/9
R Quaker Oat So Simple *(j)
Y $QHIDCELL/10
R Jordans Country Crisp *(k)
Y $QHIDCELL/11
R Quaker Crunchy Cereal *(l)
Y $QHIDCELL/12
R Quaker Oat So Simple Bars *(m)
Y $QHIDCELL/13
V E
Z
Than I need to copy it down number of times. The number of times I would need to copy it down would be defined in the second sheet where the data is stored. I've got a count already setup so it would be:
Dim CountBreaks As Long
CountBreaks = Range("A" & Rows.Count).End(xlUp).Row
Could anyone help with this??
Thanks!
I am trying to write some code in VBA and I wondered if you could help me a little?
I have to Select Rows in Column A that are between T S and V E (I've coloured the selection)
V B
V [CB] Variable for Concept Break
T S
R Product\Quaker Oat So Simple Original *(a)
Y $QHIDCELL/1
R Quaker Oat So Simple Fruity Flavours *(b)
Y $QHIDCELL/2
R Quaker Oat So Simple Classic Flavours *(c)
Y $QHIDCELL/3
R Quaker Oat So Simple Nut Clusters *(d)
Y $QHIDCELL/4
R Quaker Oat So Simple Indulgence *(e)
Y $QHIDCELL/5
R Quaker Oats *(f)
Y $QHIDCELL/6
R Quaker Oats Sustain *(g)
Y $QHIDCELL/7
R Quaker 'Grade A' Oats *(h)
Y $QHIDCELL/8
R Ready Brek *(i)
Y $QHIDCELL/9
R Quaker Oat So Simple *(j)
Y $QHIDCELL/10
R Jordans Country Crisp *(k)
Y $QHIDCELL/11
R Quaker Crunchy Cereal *(l)
Y $QHIDCELL/12
R Quaker Oat So Simple Bars *(m)
Y $QHIDCELL/13
V E
Z
Than I need to copy it down number of times. The number of times I would need to copy it down would be defined in the second sheet where the data is stored. I've got a count already setup so it would be:
Dim CountBreaks As Long
CountBreaks = Range("A" & Rows.Count).End(xlUp).Row
Could anyone help with this??
Thanks!