Thread: Form limitation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rsustudent rsustudent is offline
external usenet poster
 
Posts: 1
Default Form limitation

in excel, i've written a macro so that I can select ranges of fields
and increase the value in each cell by a set amount that I specify.
The problem, is that I want to select many sets of ranges. I can selec
somewhere around 15 or so, but past that if I try to hold control an
select another set, it unselects all the others, and acts kinda funny.
Is there something I could do to allow me to select more ranges?
here's my macro code:

Sub addit()
Dim myvar As Variant
Dim myrange As Range

myvar = Application.InputBox("Enter A value to add", Type:=3)
Set myrange = Application.InputBox("Select a Range to add it to"
Type:=8)

For Each cell In myrange.Cells
If Len(cell.Value) = 0 Then
cell.Value = cell.Value
ElseIf IsNumeric(cell.Value) = True Then _
cell.Value = cell.Value + myvar
End If
Next cell

End Su

--
Message posted from http://www.ExcelForum.com