Hi,
Excel 2003.
I am adding a series of buttons to a worksheet by selecting a particular cell, obtaining it's coordinates on the sheet, and using the add/select method.
I am getting the above message on the add/select method in the code below.
It has been working correctly, and is in fact adding one button successfully before crashing on the second button.
Any help is much appreciated.
The risk with keeping an open mind is having your brains fall out.
Shaunk
Excel 2003.
I am adding a series of buttons to a worksheet by selecting a particular cell, obtaining it's coordinates on the sheet, and using the add/select method.
I am getting the above message on the add/select method in the code below.
Code:
Range(Base_QT_Dest).Offset(QT_Columns - 2, 2).Range("A1").Select
CellX = ActiveCell.Left
CellY = ActiveCell.Top
CellH = ActiveCell.Height
CellW = ActiveCell.Width
ActiveSheet.Buttons.Add(CellX, CellY, CellW, CellH).Select
It has been working correctly, and is in fact adding one button successfully before crashing on the second button.
Any help is much appreciated.
The risk with keeping an open mind is having your brains fall out.
Shaunk