Thank you!! Your idea led to me eliminating 220 lines of code!! Geez that sure is cleaner now. Anyways, in case anyone else can benefit from this in the future, here is what I ended up with. Far from perfect, but hey, I'm just starting..
Dim Loc As String
Loc = ActiveSheet.Ran ge("Q7").Value
Dim Incr As Integer
Incr = 1
Do While Incr < 41
If Worksheets("Att achments").Rang e("B"...
Jono
Last Activity: Oct 31 '06, 05:15 AM
Joined: Oct 18 '06
Location:
-
Run-time error '1004' when closing Excel
Hello,
I've been getting this message when closing excel (not necessarily when closing the workbook by itself, but when closing Excel and the workbook at the same time):
--------------------------
Run-time error '1004':
Method of 'Worksheets' of object '_Global' failed
--------------------------
When I hit Debug, it highlights the code marked below:
--------------------------... -
I think what I really need to be doing is getting my checkboxes in an array. How do I do this? I have 40 and I want to be able to iterate through the whole set, but currently I have to refer to each individually... Any ideas?
Ie my code so far would be as follows...
With ActiveSheet
.Option1.Value = False
.Option2.Value = False
.Option3.Value = False
...Leave a comment:
-
Selecting a control based on cell information
Hello,
I have 40 option boxes in a list, beside information in cells (in excel). I want to be able to select a control (ie Control27) based on information in the cell beside it (would be cell N27 for instance), but I haven't found a way to do that. Can anyone help please?
No activity results to display
Leave a comment: