Often-Used Code not working in a new Workbook
I have the following code to transfer an option from a combobox to a
cell on one sheet. I've used this code several times before in other
workbooks, and it works absolutely fine, but, for some reason, in my
current project, it just comes up as an error and the
'Range("G11").Select' line is highlighted in yellow. Is there some
obvious or uderlying reason for this, does anyone know?
The code is:
Private Sub ComboBox1_Change()
Worksheets("How").Activate
Range("G11").Select
ActiveCell.Value = ComboBox1.Value
Worksheets("Statskeeper").Activate
End Sub
I've tried the same code in a commandbutton_click as well, but with the
same result.
Any ideas would be greatly appreciated.
Thanks
Steve
|