airbatucampur92@gmail.com
New member
- Joined
- Jul 9, 2014
- Messages
- 11
- Reaction score
- 0
- Points
- 0
Hi all,
I have this 36 list.
How to insert it in cell from range A3 to A38 when i press the button?
I try code example below, but it didt work. I think it is wrong plus i'm still new in vba.
BAR
BEE
BEI
BEM
BSG
CTM
CTO
CTS
DEG
EBK
ECT
FEE
FEI
FEM
FGA
FVI
IPR
LGS
NOX
NTM
OBA
OTH
PDR
PKG
PLA
PLM
PSG
RCV
REL
RPR
RTX
SAR
SED
SFT
SMK
SMT
Thanks!
I have this 36 list.
How to insert it in cell from range A3 to A38 when i press the button?
I try code example below, but it didt work. I think it is wrong plus i'm still new in vba.
Code:
[/COLOR]Sub test()Dim month As Variant
month = Array("Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sept", "Oct", "Nov", "Dis")
Worksheets("Sheet1").Range("C7:N7").Value = month
End Sub[COLOR=#333333]
BAR
BEE
BEI
BEM
BSG
CTM
CTO
CTS
DEG
EBK
ECT
FEE
FEI
FEM
FGA
FVI
IPR
LGS
NOX
NTM
OBA
OTH
PDR
PKG
PLA
PLM
PSG
RCV
REL
RPR
RTX
SAR
SED
SFT
SMK
SMT
Thanks!